Update using substring and charindex 1

[epkiran]

Hi, I am trying to update a part of an column containing emailadresses, and I got a tip using this:


UPDATE Student
SET EMail = SUBSTRING(EMail, 1, CHARINDEX('@', EMail) + 1) + [new.se]
WHERE (EMail LIKE [%old.se])

But I get the error message

Invalid column name 'new.se'

Is there something wrong or missing ?
new.se is not a column name, it should be the new domainadress...

I have been looking for how to use substring and charindex but I have not found any useful information...

 

[rajeevnandanmishra]

Hi there,
Try this
--------------------------

UPDATE Student
SET EMail = SUBSTRING(EMail, 1, CHARINDEX('@', EMail) + 1) + 'new.se' WHERE (EMail LIKE '%old.se')

--------------------------
Hope this will solve your problem.

 

[epkiran]

eh, just one problem left.....
the first letter in the old adress is left,
so now the new adress is onew.se....

 

[epkiran]

hepp, I removed +1 and it was OK.....