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

Answer:

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

SELECT *
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 *

*