You have a table named Sales.PotentialClients. This table contains a column named EmailAddress.
You are tasked to develop a report that returns valid “.com” email addresses from
Sales.PotentialClients.
A valid email address must have at least one character before the @ sign, and one character after
the @
sign and before the “.com.”
You need to write a TransactSQL
statement that returns data to meet the business requirements.
Which TransactSQL
statement should you use?
A.
select * from Sales.PotentialClients
where EmailAddress like ‘_%@_%.com’
B.
select * from Sales.PotentialClients
where EmailAddress like ‘%@%.com’
C.
select * from Sales.PotentialClients
where EmailAddress like ‘_%@_.com’
D.
select * from Sales.PotentialClients
where EmailAddress like ‘%@%[.]com’