A couple of people have asked me for a predefined list of states, so I thought I would post here in case anyone else needs one.
INSERT INTO `sys_pre_values` (`Key`, `Value`, `Order`, `LKey`, `LKey2`, `LKey3`, `Extra`, `Extra2`, `Extra3`) VALUES
('State', ' ', 0, '-Any-', '', '', '', '', ''),
('State', 'AA', 55, 'Armed Forces Americas (except Canada)', '', '', '', '', ''),
('State', 'AE', 54, 'Armed Forces Canada', '', '', '', '', ''),
('State', 'WY', 53, 'Wyoming', '', '', '', '', ''),
('State', 'WI', 52, 'Wisconsin', '', '', '', '', ''),
('State', 'WV', 51, 'West Virginia', '', '', '', '', ''),
('State', 'WA', 50, 'Washington', '', '', '', '', ''),
('State', 'VA', 49, 'Virginia', '', '', '', '', ''),
('State', 'VI', 48, 'Virgin Islands', '', '', '', '', ''),
('State', 'VT', 47, 'Vermont', '', '', '', '', ''),
('State', 'UT', 46, 'Utah', '', '', '', '', ''),
('State', 'TX', 45, 'Texas', '', '', '', '', ''),
('State', 'TN', 44, 'Tennessee', '', '', '', '', ''),
('State', 'SD', 43, 'South Dakota', '', '', '', '', ''),
('State', 'SC', 42, 'South Carolina', '', '', '', '', ''),
('State', 'RI', 41, 'Rhode Island', '', '', '', '', ''),
('State', 'PR', 40, 'Puerto Rico', '', '', '', '', ''),
('State', 'PA', 39, 'Pennsylvania', '', '', '', '', ''),
('State', 'PW', 38, 'Palau', '', '', '', '', ''),
('State', 'OK', 37, 'Oklahoma', '', '', '', '', ''),
('State', 'OH', 36, 'Ohio', '', '', '', '', ''),
('State', 'MP', 35, 'Northern Mariana Islands', '', '', '', '', ''),
('State', 'ND', 34, 'North Dakota', '', '', '', '', ''),
('State', 'NC', 33, 'North Carolina', '', '', '', '', ''),
('State', 'NY', 32, 'New York', '', '', '', '', ''),
('State', 'NM', 31, 'New Mexico', '', '', '', '', ''),
('State', 'NJ', 30, 'New Jersey', '', '', '', '', ''),
('State', 'NH', 29, 'New Hampshire', '', '', '', '', ''),
('State', 'NV', 28, 'Nevada', '', '', '', '', ''),
('State', 'NE', 27, 'Nebraska', '', '', '', '', ''),
('State', 'MT', 26, 'Montana', '', '', '', '', ''),
('State', 'MO', 25, 'Missouri', '', '', '', '', ''),
('State', 'MS', 24, 'Mississippi', '', '', '', '', ''),
('State', 'MN', 23, 'Minnesota', '', '', '', '', ''),
('State', 'MI', 22, 'Michigan', '', '', '', '', ''),
('State', 'MA', 21, 'Massachusetts', '', '', '', '', ''),
('State', 'MD', 20, 'Maryland', '', '', '', '', ''),
('State', 'MH', 19, 'Marshall Islands', '', '', '', '', ''),
('State', 'ME', 18, 'Maine', '', '', '', '', ''),
('State', 'LA', 17, 'Louisiana', '', '', '', '', ''),
('State', 'KY', 16, 'Kentucky', '', '', '', '', ''),
('State', 'KS', 15, 'Kansas', '', '', '', '', ''),
('State', 'IA', 14, 'Iowa', '', '', '', '', ''),
('State', 'IN', 13, 'Indiana', '', '', '', '', ''),
('State', 'IL', 12, 'Illinois', '', '', '', '', ''),
('State', 'ID', 11, 'Idaho', '', '', '', '', ''),
('State', 'HI', 10, 'Hawaii', '', '', '', '', ''),
('State', 'GU', 9, 'Guam', '', '', '', '', ''),
('State', 'GA', 8, 'Georgia', '', '', '', '', ''),
('State', 'FL', 7, 'Florida', '', '', '', '', ''),
('State', 'FM', 6, 'Federated States of Micronesia', '', '', '', '', ''),
('State', 'DC', 5, 'District of Columbia', '', '', '', '', ''),
('State', 'DE', 4, 'Delaware', '', '', '', '', ''),
('State', 'CT', 3, 'Connecticut', '', '', '', '', ''),
('State', 'CO', 2, 'Colorado', '', '', '', '', ''),
('State', 'AZ', 1, 'Arizona', '', '', '', '', '');