When to use UPPER and LOWER
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.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center