Sometimes people add multiple email addresses when they are using the “Tell a Friend” feature. What’s the best way to return rows that have more than one @ in the recipient field?
Thanks!
select <columns>
from t
where recipient like '%@%@%'
Sometimes people add multiple email addresses when they are using the “Tell a Friend” feature. What’s the best way to return rows that have more than one @ in the recipient field?
Thanks!
select <columns>
from t
where recipient like '%@%@%'