Which Transact-SQL statement should you use?

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?

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’



Leave a Reply 1

Your email address will not be published. Required fields are marked *