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 Transact-SQL statement that returns data to meet the business requirements.
Which Transact-SQL 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’
C