State and Zip Code Functions

FIPNAME

converts FIPS codes to uppercase state names

FIPNAMEL

converts FIPS codes to mixed-case state names

FIPSTATE

converts FIPS codes to two-character postal codes

GEODISTANCE

returns the geodetic distance between two latitude and longitude coordinates

STFIPS

converts state postal codes to FIPS state codes

STNAME

converts state postal codes to uppercase state names

STNAMEL

converts state postal codes to mixed-case state names

ZIPCITY

returns a city name and the two-character postal code that corresponds to a zip code

ZIPCITYDISTANCE

returns the geodetic distance between two zip code locations

ZIPFIPS

converts zip codes to FIPS state codes

ZIPNAME

converts zip codes to uppercase state names

ZIPNAMEL

converts zip codes to mixed-case state names

ZIPSTATE

converts zip codes to state postal codes