bulk domain name chnage to text in a column
-
Hi, I have a column in a table popluted with 250 email addresses as follows
etc
how can I change the domain name part for all records in one go to say the follwoing
Thank you in advance, Siz
-
Try this:
update sometable set
emailaddress = replace(emailaddress, '@cwexample.', 'cw.')
where
emailaddress like '%@cwexample.%'
-
thank for the quick reply to my question as always!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply