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.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL