sql where starts with letter code example
Example 1: sql string starts with
-- Case insensitive
SELECT * FROM my_table WHERE upper(my_column) LIKE 'SEARCHED %'; -- starts with
SELECT * FROM my_table WHERE upper(my_column) LIKE '% SEARCHED'; -- ends with
SELECT * FROM my_table WHERE upper(my_column) LIKE '%SEARCHED%'; -- contains
Example 2: sql where value like a or b
-- example
SELECT Id, ProductName, UnitPrice, Package
FROM Product
WHERE ProductName LIKE 'Cha_' OR ProductName LIKE 'Chan_'