Q: You want to display the details of all employees whose last name is Smith.
But you are not sure in which case last names are stored.

A: SELECT last name, first name FROM emp WHERE LOWER(last name) = ('smith')

Why is the answer not WHERE UPPER(last name) = ('smith')
I thought UPPER was insensitive to case?

This is a very basic question, so please help.