Question
Case Insensitve Ordering
My CFQUERY is working fine, and has for years. I am ordering
my lastname. Just recently a client joined the list with a last
name that starts with a lower case letter. As many of you know,
lowercase appears at the end in a database sort. This really screws
up my reports.
I tried using ORDER BY lower(lastName) and ORDER BY UCASE(lastName) but neither of those solutions work. They throw errors. What am I missing here? What is the best way to deal with this?
I tried using ORDER BY lower(lastName) and ORDER BY UCASE(lastName) but neither of those solutions work. They throw errors. What am I missing here? What is the best way to deal with this?
AdChoices