Write a Query to find all Employee whose name contains the word “Rich”, regardless of case. E.g. Rich, RICH, rich.


We can use UPPER function for comparing the both sides with uppercase.

FROM Employees
WHERE UPPER(emp_name) like ‘%RICH%’

Leave a Reply

Your email address will not be published. Required fields are marked *