Posted by Mintyman on 07/04/07 16:05

Cheers guys! Much appreciated :o)

"Mintyman" <mintyman@ntlworld.com> wrote in message
news:f6gap5$qgb$1$8300dec7@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!
>

[Back to original message]