I found in my SQL 2012 tables that many (hundreds) of members have .C0M in their email addresses instead of .COM. I'd like to run a script to find them and replace the .C0M with .COM. The email addresses reside in one table, but in two different columns
Any suggestions? Can I use a replace statement with a wildcard *.C0M?