HI
I am trying to join two tables in a query based on the domain name in the email
so I have
select * from account a
JOIN contact c
ON
right(c.[EMailAddress1], charindex('@', reverse(c.[EMailAddress1]))-1) = right(a.[EMailAddress1], charindex('@', reverse(a.[EMailAddress1]))-1)
which gives me the domain name in both emails.
but when I run the query I get a failure when an email address has no @ sign ( few are empty)
any idea whats the best way to deal with that in the query join.
Thanks
Nick Mason