In almost every project I have worked on, I have needed the list of US states in a format to insert into a database. I am finally tired of recreating this list, and posting it for future use...
create table USStates(USStateCd char(2) not null, USStateName varchar(30) not null);
insert into USStates(USStateCd, USStateName) values ('AL','Alabama');
insert into USStates(USStateCd, USStateName) values ('AK','Alaska');
insert into USStates(USStateCd, USStateName) values ('AZ','Arizona');
insert into USStates(USStateCd, USStateName) values ('AR','Arkansas');
insert into USStates(USStateCd, USStateName) values ('CA','California');
insert into USStates(USStateCd, USStateName) values ('CO','Colorado');
insert into USStates(USStateCd, USStateName) values ('CT','Connecticut');
insert into USStates(USStateCd, USStateName) values ('DE','Delaware');
insert into USStates(USStateCd, USStateName) values ('DC','District of Columbia');
insert into USStates(USStateCd, USStateName) values ('FL','Florida');
insert into USStates(USStateCd, USStateName) values ('GA','Georgia');
insert into USStates(USStateCd, USStateName) values ('HI','Hawaii');
insert into USStates(USStateCd, USStateName) values ('ID','Idaho');
insert into USStates(USStateCd, USStateName) values ('IL','Illinois');
insert into USStates(USStateCd, USStateName) values ('IN','Indiana');
insert into USStates(USStateCd, USStateName) values ('IA','Iowa');
insert into USStates(USStateCd, USStateName) values ('KS','Kansas');
insert into USStates(USStateCd, USStateName) values ('KY','Kentucky');
insert into USStates(USStateCd, USStateName) values ('LA','Louisiana');
insert into USStates(USStateCd, USStateName) values ('ME','Maine');
insert into USStates(USStateCd, USStateName) values ('MD','Maryland');
insert into USStates(USStateCd, USStateName) values ('MA','Massachusetts');
insert into USStates(USStateCd, USStateName) values ('MI','Michigan');
insert into USStates(USStateCd, USStateName) values ('MN','Minnesota');
insert into USStates(USStateCd, USStateName) values ('MS','Mississippi');
insert into USStates(USStateCd, USStateName) values ('MO','Missouri');
insert into USStates(USStateCd, USStateName) values ('MT','Montana');
insert into USStates(USStateCd, USStateName) values ('NE','Nebraska');
insert into USStates(USStateCd, USStateName) values ('NV','Nevada');
insert into USStates(USStateCd, USStateName) values ('NH','New Hampshire');
insert into USStates(USStateCd, USStateName) values ('NJ','New Jersey');
insert into USStates(USStateCd, USStateName) values ('NM','New Mexico');
insert into USStates(USStateCd, USStateName) values ('NY','New York');
insert into USStates(USStateCd, USStateName) values ('NC','North Carolina');
insert into USStates(USStateCd, USStateName) values ('ND','North Dakota');
insert into USStates(USStateCd, USStateName) values ('OH','Ohio');
insert into USStates(USStateCd, USStateName) values ('OK','Oklahoma');
insert into USStates(USStateCd, USStateName) values ('OR','Oregon');
insert into USStates(USStateCd, USStateName) values ('PA','Pennsylvania');
insert into USStates(USStateCd, USStateName) values ('RI','Rhode Island');
insert into USStates(USStateCd, USStateName) values ('SC','South Carolina');
insert into USStates(USStateCd, USStateName) values ('SD','South Dakota');
insert into USStates(USStateCd, USStateName) values ('TN','Tennessee');
insert into USStates(USStateCd, USStateName) values ('TX','Texas');
insert into USStates(USStateCd, USStateName) values ('UT','Utah');
insert into USStates(USStateCd, USStateName) values ('VT','Vermont');
insert into USStates(USStateCd, USStateName) values ('VA','Virginia');
insert into USStates(USStateCd, USStateName) values ('WA','Washington');
insert into USStates(USStateCd, USStateName) values ('WV','West Virginia');
insert into USStates(USStateCd, USStateName) values ('WI','Wisconsin');
insert into USStates(USStateCd, USStateName) values ('WY','Wyoming');
Posted
Dec 14 2006, 08:48 AM
by
jsmith