I have data like:
In a SQL 2005 Database (4 columns in my example). I need to do a SQL * select query so that for records with a "6" in Col 1, it will replace the 6 with the letter "C" in the output. Also, the query would only select records with a 6 in Col 1 (where Col1=6). Is there an easy way to do replacements in SQL queries?