Which of the following operators is used when the criteria is based upon a search pattern?
A) AND
B) LIKE
C) IS NULL
D) BETWEEN...AND

Question

Which of the following operators is used when the criteria is based upon a search pattern?​
A) ​AND
B) ​LIKE
C) ​IS NULL
D) ​BETWEEN...AND

Quizplus · Accepted Answer

The LIKE operator is used for pattern matching within a string. It is often used with the wildcard character (%) to match any pattern before or after a specified string. The other operators listed do not involve pattern matching.

Which of the Following Operators Is Used When the Criteria