statename(
statename(
STATE
)

The statename( function converts a two letter abbreviation for a US state into the full state name.

Parameters

This function has one parameter:

state – The two letter abbreviation for the state name.

Description

This function converts a two letter abbreviation for a US state into the full state name.

    statename("CA") ☞ California
    statename("CO") ☞ Colorado
    statename("AB") ☞

This function is identical to the statelookup( function, except for the fact that if the state does not exist, the statelookup( function returns the original string instead of `""`.

Note: This function is equivalent to:

    upperword(arraylookup(stateAbbreviations(),upper(thestate),";",":",""))

See Also

- city( -- looks up the name of a city associated with a US zip code.
- cityzip( -- returns the lowest zip code associated with a city.
- cityzips( -- returns a list of zip codes associated with a city.
- county( -- returns the name of the county associated with a US zip code.
- mapurl( -- returns a URL to display a map location.
- openmapwindow -- opens a window displaying a map of a location.
- openwebmap -- opens a web browser window displaying a map of a location.
- selectzipdistancetool -- selects records near the current record, based on zip codes.
- state( -- returns the name of the state associated with a US zip code.
- stateabbreviations( -- returns a list of US state abbreviations.
- statelookup( -- converts a two letter abbreviation for a US state into the full state name.
- uspssecondaryunits( -- returns a list of USPS (United States Postal Service) secondary suffix designation abbreviations.
- uspsstreetsuffixes( -- returns a list of USPS street suffix abbreviations.
- zipdistance( -- calculates the distance between two zip codes.
- ziplatitude( -- returns the latitude of a US zip code.
- ziplongitude( -- returns the longitude of a US zip code.

History

Version | Status | Notes
10.0 | New | New in this version.