A table named Contacts includes a column named SmtpAddress. You must develop a report that returns e-mail addresses from the Contacts table that have the following format: at least one character, the at sign (@), at least one character, and then ".org". You need to return data that meets the requirements. Which Transact-SQL statement should you use?

Question

Accepted Answer

B. Select * from Contacts where SmtpAddress like '_%@_%.org'

Answer

A. Select * from Contacts where SmtpAddress like '%@%[.]org'

Answer

C. Select * from Contacts where SmtpAddress like '_%@_.org'

Answer

D. Select * from Contacts where SmtpAddress like '%@%.org'

A table named Contacts includes a column named SmtpAddress. You must develop a report that returns e-mail addresses from the Contacts table that have the following format: at least one character…

Question

Options

How the community answered

Community Discussion