I figured out a way to do it using STUFF and CHARINDEX
stuff(column name, charindex('@', column name),1, 'a') THis will replace your @'s with a's but if you have a column without an @ it gives you a null. I think you may have to use a case to solve that problem, I'm working on that now, but I...