Microsoft SQL Valid Emails with Regex Regular Expressions

--Microsoft SQL Valid Emails with Regex Regular Expressions

-- find email addresses with valid format

select *, 'emails valid' [is valid?]
from [dbo].[options on fx majors]
where email like '%[a-zA-Z0-9][@][a-zA-Z0-9]%[.][a-zA-Z]%'

-- find email addresses without valid format

union all

select *, 'emails not valid' [is valid?]
from [dbo].[options on fx majors]
where email not like '%[a-zA-Z0-9][@][a-zA-Z0-9]%[.][a-zA-Z]%';