Um...if you use LOWER in the ORDER BY clause, it has no affect on the data or the way it's displayed, it just reads all records as lower case so you get an accurate comparison.
1) What's the point in having a second query that just selects everything from the first query? It's a waste of time and resources. Now you have 2 sets of the exact same info.
2) Have you tried "ORDER by LOWER(LName)"?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.