SQLTeam.com | Weblogs | Forums

Check which email address contains a number

I can get the number 1,2 3 etc. by changing each time but is there a way to get any email address that has a number?
select id_number, first_name, last_name, work_email,
case
when work_email like '%[1]%' then work_email
else ''
end
from staff_view
where end_date is null

case
when work_email like '%[0-9]%' then work_email

1 Like