Which codes does [ABC]% catch?

Question

Accepted Answer

[ABC]% matches any string whose first character is A, B, or C. Apple starts with A, Banana with B, Cherry with C - all three match. Durian starts with D, which is not in the bracket set, so it is excluded. Note that bracket patterns are a T-SQL extension and are not standard SQL; PostgreSQL uses similar syntax in some contexts but standard SQL does not support them.