Home » MCQs » Transact-SQL (T-SQL) MCQs

What will be the output of the below LIKE query (3)?

12. What will be the output of the below LIKE query?

WHERE SALARY LIKE '8_%_%.'

1. It will find any value that starts with 8 and has more than 3 characters in length
2. It will find any value that starts with 8 and has only 2 characters in length
3. It will find any value that starts with 8 and have at least 1 character in length
4. It will find any value that starts with 8 and has at least 3 characters in length.

Answer: D) It will find any value that starts with 8 and has at least 3 characters in length.

Explanation:

It finds any value that starts with 8 and has at least 3 characters in length.