How To Use Wildcard Characters in LIKE Operations?

Question

Amit Singh · Answer

Wildcard character '%' can be used in the pattern string for the LIKE operator to match any string of zero or more characters.
for example:
SELECT c.CompName FROM Company c
WHERE c.CompName LIKE '%Mind% Stick'

interview

How To Use Wildcard Characters in LIKE Operations?

Can you answer this question?

1 Answers