ADDZIP

Returns specified field from Zip Code database.

Reporting Area(s):

General

Required Parameters:

1. Zip Code field (i.e. nmzip, fmzip, inzip)

--OR-- Zip Code character string (i.e. "66502")

2. Field from Zip Code table to return (i.e. "zipcity", "zipstate")

Optional Parameters:

None

Example(s):

ADDZIP(nmzip, "zipcity") returns the zip code's city

ADDZIP("66502","ziparea") returns the zip code's area code

 

Related Topics