I recently had to modify a mySql database to replace postal codes (i.e., "FL") with complete state names (i.e., "Florida"). I searched all over and did not find a ready-made string to accomplish this.
I am sure somewhere that someone will find this useful.
Simply replace "dbo_vwPRVDR" with your table name, and "State" with the column name, [...]