{"id":392,"date":"2013-02-04T17:47:01","date_gmt":"2013-02-04T22:47:01","guid":{"rendered":"https:\/\/danvanfleet.com\/?p=392"},"modified":"2013-03-11T13:31:52","modified_gmt":"2013-03-11T18:31:52","slug":"crystal-reports-state-letter-to-state-name","status":"publish","type":"post","link":"https:\/\/danvanfleet.com\/index.php\/crystal-reports-state-letter-to-state-name\/","title":{"rendered":"Crystal Reports, State Letter to State Name"},"content":{"rendered":"

From time to time I need a formula to convert a database stored state letter into a state name. Replace Search.StateLet with your database column.  This formula is setup to work with a SoftPro<\/a> ProForm Report.<\/p>\n

<\/p>\n

 <\/p>\n

\n
\n
Select<\/span> {Search<\/span>.StateLet}<\/pre>\n
<\/p>\n
   case<\/span> \"AB\" : \"Alberta\"<\/pre>\n
<\/p>\n
case<\/span> \"AK\" : \"Alaska\"<\/pre>\n
<\/p>\n
case<\/span> \"AL\" : \"Alabama\"<\/pre>\n
<\/p>\n
case<\/span> \"AR\" : \"Arkansas\"<\/pre>\n
<\/p>\n
case<\/span> \"AS<\/span>\" : \"American Samoa\"<\/pre>\n
<\/p>\n
case<\/span> \"AZ\" : \"Arizona\"<\/pre>\n
<\/p>\n
case<\/span> \"BA\" : \"Bahamas\"<\/pre>\n
<\/p>\n
case<\/span> \"BC\" : \"British Columbia\"<\/pre>\n
<\/p>\n
case<\/span> \"CA\" : \"California\"<\/pre>\n
<\/p>\n
case<\/span> \"CO\" : \"Colorado\"<\/pre>\n
<\/p>\n
case<\/span> \"CT\" : \"Connecticut\"<\/pre>\n
<\/p>\n
case<\/span> \"DC\" : \"District of<\/span> Columbia\"<\/pre>\n
<\/p>\n
case<\/span> \"DE\" : \"Delaware\"<\/pre>\n
<\/p>\n
case<\/span> \"FL\" : \"Florida\"<\/pre>\n
<\/p>\n
case<\/span> \"GA\" : \"Georgia\"<\/pre>\n
<\/p>\n
case<\/span> \"GU\" : \"Guam\"<\/pre>\n
<\/p>\n
case<\/span> \"HI\" : \"Hawaii\"<\/pre>\n
<\/p>\n
case<\/span> \"IA\" : \"Iowa\"<\/pre>\n
<\/p>\n
case<\/span> \"ID\" : \"Idaho\"<\/pre>\n
<\/p>\n
case<\/span> \"IL\" : \"Illinois\"<\/pre>\n
<\/p>\n
case<\/span> \"IN<\/span>\" : \"Indiana\"<\/pre>\n
<\/p>\n
case<\/span> \"KS\" : \"Kansas\"<\/pre>\n
<\/p>\n
case<\/span> \"KY\" : \"Kentucky\"<\/pre>\n
<\/p>\n
case<\/span> \"LA\" : \"Louisiana\"<\/pre>\n
<\/p>\n
case<\/span> \"MA\" : \"Massachusetts\"<\/pre>\n
<\/p>\n
case<\/span> \"MB\" : \"Manitoba\"<\/pre>\n
<\/p>\n
case<\/span> \"MD\" : \"Maryland\"<\/pre>\n
<\/p>\n
case<\/span> \"ME\" : \"Maine\"<\/pre>\n
<\/p>\n
case<\/span> \"MI\" : \"Michigan\"<\/pre>\n
<\/p>\n
case<\/span> \"MN\" : \"Minnesota\"<\/pre>\n
<\/p>\n
case<\/span> \"MO\" : \"Missouri\"<\/pre>\n
<\/p>\n
case<\/span> \"MS\" : \"Mississippi\"<\/pre>\n
<\/p>\n
case<\/span> \"MT\" : \"Montana\"<\/pre>\n
<\/p>\n
case<\/span> \"NB\" : \"New<\/span> Brunswick\"<\/pre>\n
<\/p>\n
case<\/span> \"NC\" : \"North Carolina\"<\/pre>\n
<\/p>\n
case<\/span> \"ND\" : \"North Dakota\"<\/pre>\n
<\/p>\n
case<\/span> \"NE\" : \"Nebraska\"<\/pre>\n
<\/p>\n
case<\/span> \"NH\" : \"New<\/span> Hampshire\"<\/pre>\n
<\/p>\n
case<\/span> \"NJ\" : \"New<\/span> Jersey\"<\/pre>\n
<\/p>\n
case<\/span> \"NL\" : \"Newfoundland\"<\/pre>\n
<\/p>\n
case<\/span> \"NM\" : \"New<\/span> Mexico\"<\/pre>\n
<\/p>\n
case<\/span> \"NS\" : \"Nova Scotia\"<\/pre>\n
<\/p>\n
case<\/span> \"NT\" : \"Northwest Territory\"<\/pre>\n
<\/p>\n
case<\/span> \"NU\" : \"Nunavut\"<\/pre>\n
<\/p>\n
case<\/span> \"NV\" : \"Nevada\"<\/pre>\n
<\/p>\n
case<\/span> \"NY\" : \"New<\/span> York\"<\/pre>\n
<\/p>\n
case<\/span> \"OH\" : \"Ohio\"<\/pre>\n
<\/p>\n
case<\/span> \"OK\" : \"Oklahoma\"<\/pre>\n
<\/p>\n
case<\/span> \"ON<\/span>\" : \"Ontario\"<\/pre>\n
<\/p>\n
case<\/span> \"OR<\/span>\" : \"Oregon\"<\/pre>\n
<\/p>\n
case<\/span> \"PA\" : \"Pennsylvania\"<\/pre>\n
<\/p>\n
case<\/span> \"PE\" : \"Prince Edward Island\"<\/pre>\n
<\/p>\n
case<\/span> \"PR\" : \"Puerto Rico\"<\/pre>\n
<\/p>\n
case<\/span> \"QC\" : \"Province of<\/span> Quebec\"<\/pre>\n
<\/p>\n
case<\/span> \"RI\" : \"Rhode Island\"<\/pre>\n
<\/p>\n
case<\/span> \"SC\" : \"South Carolina\"<\/pre>\n
<\/p>\n
case<\/span> \"SD\" : \"South Dakota\"<\/pre>\n
<\/p>\n
case<\/span> \"SK\" : \"Saskatchewan\"<\/pre>\n
<\/p>\n
case<\/span> \"TN\" : \"Tennessee\"<\/pre>\n
<\/p>\n
case<\/span> \"TX\" : \"Texas\"<\/pre>\n
<\/p>\n
case<\/span> \"UT\" : \"Utah\"<\/pre>\n
<\/p>\n
case<\/span> \"VA\" : \"Virginia\"<\/pre>\n
<\/p>\n
case<\/span> \"VI\" : \"Virgin Islands\"<\/pre>\n
<\/p>\n
case<\/span> \"VT\" : \"Vermont\"<\/pre>\n
<\/p>\n
case<\/span> \"WA\" : \"Washington\"<\/pre>\n
<\/p>\n
case<\/span> \"WI\" : \"Wisconsin\"<\/pre>\n
<\/p>\n
case<\/span> \"WV\" : \"West Virginia\"<\/pre>\n
<\/p>\n
case<\/span> \"WY\" : \"Wyoming\"<\/pre>\n
<\/p>\n
case<\/span> \"YT\" : \"Yukon Territory\"<\/pre>\n
<\/p>\n
case<\/span> \"\" : \"\";<\/pre>\n
<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
From time to time I need a formula to convert a database stored state letter into a state name. Replace Search.StateLet with your database column.  This formula is setup to work with a SoftPro ProForm Report.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[23,5],"tags":[21,27],"class_list":["post-392","post","type-post","status-publish","format-standard","hentry","category-softpro-2","category-using-computers","tag-proform","tag-reports","entry"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4wyVb-6k","jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/posts\/392","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/comments?post=392"}],"version-history":[{"count":2,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/posts\/392\/revisions"}],"predecessor-version":[{"id":506,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/posts\/392\/revisions\/506"}],"wp:attachment":[{"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/media?parent=392"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/categories?post=392"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/tags?post=392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}