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 Functions

BIGSTATE
CSZR
NOSTATE