xxxxxxxxxx
-- 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
xxxxxxxxxx
select employee_name
from employees
where employee_name LIKE 'A%' OR employee_name LIKE 'B%'
order by employee_name