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…