Question

Which one of the following SQL queries will display all Employee records containing the word "Amit", regardless of case (whether it was stored as AMIT, Amit, or amit etc.)?

(i) SELECT * from Employees WHERE EmpName like UPPER '%AMIT%'';

(ii)  SELECT * from Employees WHERE EmpName like '%AMIT%' or '%AMIT%' or '%AMIT%';

(iii) SELECT * from Employees WHERE UPPER (EmpName) like '%AMIT%';

Answer 1

The correct answer:

(iii) SELECT * from Employees WHERE UPPER (EmpName) like '%AMIT%';