Consider the need to query for a certain pattern of data within a column. The example I'll use are customers with Canadian postal codes.
ID Postal -- ------- 442 90210 631 T0R 4C2 447 YO31 1EB 145 F9S8S6 73 K9J 3K3
Pretend you don't have an easy out (like a state/prov or country field), or that you're running a non-conformance report. Yes, don't trust user input!
-- we want to find: three chars + space + 3 chars 'XXX XXX'
-- LIKE % is not terribly helpful
SELECT * FROM SomeTable
WHERE Postal LIKE --?
We want the resultset to be
ID Postal -- ------- 631 T0R 4C2 73 K9J 3K3
Question: how would you formulate that LIKE
clause?