SQLTeam.com | Weblogs | Forums

Check emails

I have a table, 'Staff' with a column with an email field. The email field is required on the entry form so they all are populated.
I am trying to see in the data set which emails have a number as a part of the address for example Jonathan1@someorg.org we would want the entire record, but say
Jonathan@someorg.org we would not want.

select 
     case 
          when email_column like '%[0-9]%' then email_column  
          else '' 
     end
3 Likes

WHERE email LIKE '%[0-9]%@%'

1 Like