View Single Post

   
  #2 (permalink)  
Old 03-01-2008, 02:25 PM
PBsoft
 
Posts: n/a
Default Re: Find website from email address

> 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
skypebsoftsolution


Reply With Quote