Posted by PBsoft on 07/04/07 15:41

> Would anyone be able to help me with the SQL that would take whatever
> is after the '@' sign in the email address, add it to 'www.' and
> populate the 'website' field?

UPDATE yourtable
SET Site = SUBSTRING(yourtable.email, CHARINDEX('@', yourtable.email) + 1,
LEN(yourtable.email) - CHARINDEX('@', yourtable.email))

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype:pbsoftsolution

• Next in forum: Re: MS SQL getDate() Function remove Time
• Prev in forum: Re: MS SQL getDate() Function remove Time
• Thread view: Re: Find website from email address

[Reply to this message]