Find website from email address

[Mintyman]

Hi,

I have 2 fields in a database: 'email' and 'website'.

In the majority of cases, the website field is not populated even though the
email address is. In 90% of cases, the website will be 'www.' followed by
whatever is after the '@' symbol in the 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?

Thanks!

[PBsoft]

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

[Dan Guzman]

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?

Here's one method:

UPDATE dbo.MyTable
SET website =
CASE WHEN CHARINDEX('@', email) 0 AND CHARINDEX('@', email) + 1 <
LEN(email) THEN
'www.' + SUBSTRING(email, CHARINDEX('@', email) + 1, 255)
ELSE
website
END
WHERE
website IS NULL OR
website = ''

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Mintyman" <mi******@ntlworld.comwrote in message
news:f6*******************@news.demon.co.uk...

Hi,

I have 2 fields in a database: 'email' and 'website'.

In the majority of cases, the website field is not populated even though
the email address is. In 90% of cases, the website will be 'www.' followed
by whatever is after the '@' symbol in the 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?

Thanks!

[Mintyman]

Cheers guys! Much appreciated :o)

"Mintyman" <mi******@ntlworld.comwrote in message
news:f6*******************@news.demon.co.uk...

Hi,

I have 2 fields in a database: 'email' and 'website'.

In the majority of cases, the website field is not populated even though
the email address is. In 90% of cases, the website will be 'www.' followed
by whatever is after the '@' symbol in the 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?

Thanks!