Comma delimited list of United States Abbreviations

I’m putting this here because I sometimes need a comma delimited list of the fifty states.

"AL","AK","AZ","AR","CA","CO","CT","DE","FL","GA","HI","ID","IL","IN","IA","KS","KY","LA","ME","MD","MA","MI","MN","MS","MO","MT","NE","NV","NH","NJ","NM","NY","NC","ND","OH","OK","OR","PA","RI","SC","SD","TN","TX","UT","VT","VA","WA","WV","WI","WY"

9 thoughts on “Comma delimited list of United States Abbreviations”

  1. and here is the same list where single quotes are required.

    ‘AL’,’AK’,’AZ’,’AR’,’CA’,’CO’,’CT’,’DE’,’FL’,’GA’,’HI’,’ID’,’IL’,’IN’,’IA’,’KS’,’KY’,’LA’,’ME’,’MD’,’MA’,’MI’,’MN’,’MS’,’MO’,’MT’,’NE’,’NV’,’NH’,’NJ’,’NM’,’NY’,’NC’,’ND’,’OH’,’OK’,’OR’,’PA’,’RI’,’SC’,’SD’,’TN’,’TX’,’UT’,’VT’,’VA’,’WA’,’WV’,’WI’,’WY’

  2. ‘AB’, ‘BC’, ‘MB’, ‘NB’, ‘NL’, ‘NS’, ‘NT’, ‘NU’, ‘ON’, ‘PE’, ‘QC’, ‘SK’, ‘YT’

    Canadian provinces and territories.

  3. sorry this will work better with MS SQL
    ‘AB’, ‘BC’, ‘MB’, ‘NB’, ‘NL’, ‘NS’, ‘NT’, ‘NU’, ‘ON’, ‘PE’, ‘QC’, ‘SK’, ‘YT’

Leave a Reply

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