Update part of column 1

[epkiran]

I got a tip using this statement in order to update the domain adress in an emailadress, but I have problem with the function instr......

UPDATE Table
SET Column = Left([Column], instr([Column],"@&quot) & "new.se"
WHERE Column LIKE "*old.se"

 

[rajeevnandanmishra]

Hi there,
Try this:
-----------------
UPDATE Table
SET Column = SUBSTRING([Column],1,charindex('@',[Column])+1)+"new.se" WHERE Column LIKE "%old.se"
-----------------