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!