Posted by Mintyman on 07/04/07 14:27

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!

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

[Reply to this message]