April 22, 2005 at 2:02 pm
Hello.
One of my co-workers has just asked if I can correct an error made during data entry:
Change: all.user@thewebaddress.org to all.user@webaddress.org
I only have to take the "the" out of the address. Is there some T-SQL guru who can show me the light?
April 22, 2005 at 2:13 pm
Update dbo.YourTable SET YourColumn = Replace(YourColumn, '@thewebaddress.org', '@webaddress.org')
April 22, 2005 at 3:06 pm
If you can verify that "the" is only used within "thewebaddress" and you want to avoid some keystrokes, this should also work
UPDATE....REPLACE('all.user@thewebaddress.org', 'the', '')
But you might be on the safer side with Remi's suggestion.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply