PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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’

One Comment on “Which Transact-SQL statement should you use?


Leave a Reply