The county( function returns the name of the county associated with a US zip code.
This function has one parameter:
zipcode – is a US 5 digit zip code. You can specify the zip code either as a number or as text.
The function returns the name of the county associated with a US zip code. If there is no zip code with the specified number, the function will return
county(92648) ☞ Orange county("20401") ☞ District of Columbia county(99999) ☞ -
One primary use for the county( function is to enter the county automatically when the zip code is entered, saving keystrokes and reducing the probability of data entry errors. This example assumes that the database has a ZipCode field that contains text. The example uses a text funnel to strip off any extra characters in the zip code (for example 9 digit zip codes).
Another use for the county( function is to double-check data entry. This example locates all records where the zip code does not match the county name.
select County <> county(ZipCode[1,5])
|10.0||No Change||Carried over from Panorama 6.0.|