Convert state name to 2-character code

R

R. Choate

Is there a formula or code snippet which will convert the occasional long state name to the 2-character code? I've got a real mess
to clean up

Thanks!
 
J

John Mishefske

R. Choate said:
Is there a formula or code snippet which will convert the occasional long state name to the 2-character code? I've got a real mess
to clean up
Click to expand...

No. I'd suggest you create a new table with state name and abbreviations
(source: http://www.usps.com/ncsc/lookups/abbr_state.txt)
and do an update query.

--
John Mishefske, Microsoft MVP 2007 - 2009
UtterAccess Editor
Tigeronomy Software
web: http://www.tigeronomy.com
email: sales ~at~ tigeronomy.com
 
Top