UPDATE part of column using Wildcard?

[epkiran]

I want to update the column emailadress
but only the domainadress..


UPDATE Table
SET Column LIKE '%new.se'
WHERE Column LIKE '%old.se'

but it seems to be impossible using wildcards
in the SET-statement...

 

[tlbroadbent]

You are correct. You cannot use LIKE in the SET statement. Also, JET prefers * rather than % for the wildcard character. You can try this statement.

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

http://members.home.net/tlbroadbent/sqlarticles.htm

"I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes