When geographic data is stored in a database, it is often stored in abbreviated format. Use these functions to expand the abbreviation to its full-text equivalent. Modify the functions to handle data beyond the United States and Canada.
cdExpandRegionAbbreviation Given a region abbreviation and a country, returns the full text of the region; supplied function handles Canada and United States only.
cdExpandRegionAbbreviationCanada Given a Canadian abbreviation like "AB," returns the full text of a phrase like "Alberta."
cdExpandRegionAbbreviationUSA Given a United States state abbreviation like "NY," returns the full text of a phrase like "New York."