Multiple choice technology databases

What operator performs pattern matching?

  1. &

  2. LIKE

  3. %

  4. NONE
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

LIKE is the pattern matching operator in SQL Server. It's used in WHERE clauses to search for patterns using wildcards like % (any string) and _ (single character). The & operator (option A) is for bitwise operations, % is modulo division in arithmetic, and LIKE (option B) is specifically designed for pattern matching in character data.

Keep practicing — related questions