Question

What is the meaning of LIKE ‘%0%0%’?

(a) Feature begins with two 0’s

(b) Feature ends with two 0’s

(c) Feature has more than two 0’s

(d) Feature has two 0’s in it, at any position

This question was posed to me in an international level competition.

Query is from Basic SQL in portion Laying the Foundation of SQL Server

Answer 1

The correct option is (d) Feature has two 0’s in it, at any position

Easiest explanation: The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.