specifies a character
expression that contains the two-character standard state postal code.
Characters can be mixed case. The function ignores trailing blanks,
but generates an error if the expression contains leading blanks.
Details
The STFIPS function
converts a two-character state postal code (or world-wide GSA geographic
code for U.S. territories) to the corresponding numeric U.S. Federal
Information Processing Standards (FIPS) code.
Comparisons
The STFIPS, STNAME, and
STNAMEL functions take the same argument but return different values.
STFIPS returns a numeric U.S. Federal Information Processing Standards
(FIPS) code. STNAME returns an uppercase state name. STNAMEL returns
a mixed case state name.
Example
The following examples
show the differences when using STFIPS, STNAME, and STNAMEL.