How do I remove characters from my data in SQL 2005
I'm trying to remove the SMTP: prefix from my column. How do I do this?
UPDATE EmpDetails
SET MgrEmail = REPLACE(MgrEmail, SUBSTRING(MgrEmail, PATINDEX('SMTP:', MgrEmail), 1), '')
WHERE PATINDEX('SMTP:', MgrEmail) <> 0
UPDATE EmpDetails
SET MgrEmail = REPLACE(MgrEmail, SUBSTRING(MgrEmail, PATINDEX('SMTP:', MgrEmail), 1), '')
WHERE PATINDEX('SMTP:', MgrEmail) <> 0
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER