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%’

Read the full book at www.amazon.com
Posted in SQL, SQL Interview Questions

Leave a Reply

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