Provinces
Martech Zone articles tagged provinces:
-
Content Marketing
SQL: Full Name Lookup for States and Provinces for the US and Canada
While working on a Google Mapping project this weekend, I needed to make a table in MySQL that translated the 2-digit country and state abbreviations to a full name. I’m sure this is something that is needed quite a bit, so I’ve put the SQL file up on my server for download. Here’s the SQL statement for State and Province…