Home on the web ~ Dan Van Fleet

Information on SoftPro ProForm with some general computer tips and techniques, with a bit of me.

Home on the web ~ Dan Van Fleet - Information on SoftPro ProForm with some general computer tips and techniques, with a bit of me.

Crystal Reports, State Letter to State Name

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 "" : "";

Help support the site when shopping on Amazon, click through any ad to get to Amazon, ignore that product, then buy whatever you're there for. Thanks for helping out.

Your email address will not be published. Required fields are marked *

*

css.php