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

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchWindowsServer

Search400

  • 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 ...

SearchEnterpriseLinux

SearchDataCenter

SearchExchange

SearchContentManagement

Close