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.
Select {Search.StateLet}
case "AB" : "Alberta"
case "AK" : "Alaska"
case "AL" : "Alabama"
case "AR" : "Arkansas"
case "AS" : "American Samoa"
case "AZ" : "Arizona"
case "BA" : "Bahamas"
case "BC" : "British Columbia"
case "CA" : "California"
case "CO" : "Colorado"
case "CT" : "Connecticut"
case "DC" : "District of Columbia"
case "DE" : "Delaware"
case "FL" : "Florida"
case "GA" : "Georgia"
case "GU" : "Guam"
case "HI" : "Hawaii"
case "IA" : "Iowa"
case "ID" : "Idaho"
case "IL" : "Illinois"
case "IN" : "Indiana"
case "KS" : "Kansas"
case "KY" : "Kentucky"
case "LA" : "Louisiana"
case "MA" : "Massachusetts"
case "MB" : "Manitoba"
case "MD" : "Maryland"
case "ME" : "Maine"
case "MI" : "Michigan"
case "MN" : "Minnesota"
case "MO" : "Missouri"
case "MS" : "Mississippi"
case "MT" : "Montana"
case "NB" : "New Brunswick"
case "NC" : "North Carolina"
case "ND" : "North Dakota"
case "NE" : "Nebraska"
case "NH" : "New Hampshire"
case "NJ" : "New Jersey"
case "NL" : "Newfoundland"
case "NM" : "New Mexico"
case "NS" : "Nova Scotia"
case "NT" : "Northwest Territory"
case "NU" : "Nunavut"
case "NV" : "Nevada"
case "NY" : "New York"
case "OH" : "Ohio"
case "OK" : "Oklahoma"
case "ON" : "Ontario"
case "OR" : "Oregon"
case "PA" : "Pennsylvania"
case "PE" : "Prince Edward Island"
case "PR" : "Puerto Rico"
case "QC" : "Province of Quebec"
case "RI" : "Rhode Island"
case "SC" : "South Carolina"
case "SD" : "South Dakota"
case "SK" : "Saskatchewan"
case "TN" : "Tennessee"
case "TX" : "Texas"
case "UT" : "Utah"
case "VA" : "Virginia"
case "VI" : "Virgin Islands"
case "VT" : "Vermont"
case "WA" : "Washington"
case "WI" : "Wisconsin"
case "WV" : "West Virginia"
case "WY" : "Wyoming"
case "YT" : "Yukon Territory"
case "" : "";
Category: SoftPro, Using Computers