50 States For Categorized Field

List of all 50 states to paste into a categorized "state" field so that users select using the name of the state...

but the application stores the state as the 2 digit abbreviation. We have added a few additional common non-states like providence in Canada, etc. 1. Go to a state field 2. Change the TYPE to Keyword 3. Change the CHOICES to Enter Choices (One Per Line) 4. Past the following in the data field Alabama|AL Alaska|AK Alberta Arizona|AZ Arkansas|AR British Columbia California|CA Colorado|CO Connecticut|CT Delaware|DE District of Columbia|DC Florida|FL Georgia|GA Hawaii|HI Idaho|ID Illinois|IL Indiana|IN Iowa|IA Kansas|KS Kentucky|KY Louisiana|LA Maine|ME Manitoba Maryland|MD Massachusetts|MA Michigan|MI Minnesota|MN Mississippi|MS Missouri|MO Montana|MT Nebraska|NE Nevada|NV New Brunswick New Hampshire|NH New Jersey|NJ New Mexico|NM New York|NY Newfoundland North Carolina|NC North Dakota|ND Northwest Territories Nova Scotia Ohio|OH Oklahoma|OK Ontario|ON Oregon|OR Pennsylvania|PA Prince Edward Island Puerto Rico|PR Quebec Rhode Island|RI Saskatchewan South Carolina|SC South Dakota|SD Tennessee|TN Texas|TX Utah|UT Vermont|VT Virginia|VA Washington|WA West Virginia|WV Wisconsin|WI Wyoming|WY Yukon

This was first published in November 2000

Dig Deeper



Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:




  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...