1SELECT * FROM table_name WHERE UPPER(col_name) LIKE '%SEARCHED%';
2SELECT * FROM table_name WHERE col_name LIKE '%Searched%'; -- Case sensitive
3
4SYMBOL DESCRIPTION (SQL) EXAMPLE
5% zero or more characters bl% 'bl, black, blue, blob'
6_ a single character h_t 'hot, hat, hit'
7[] any single character within brackets h[oa]t 'hot, hat', but NOT 'hit'
8^ any character not in the brackets h[^oa]t 'hit', but NOT 'hot, hat'
9- a range of characters [a-b]t 'cat, cbt'
1-- example
2SELECT Id, ProductName, UnitPrice, Package
3 FROM Product
4 WHERE ProductName LIKE 'Cha_' OR ProductName LIKE 'Chan_'