Language Reference
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 |
Last updated: July 20, 2026