how to sort case insensitive?
I have a column that has text and numbers. The text is mixed case and the users want to input and see the data displayed that way.
When I do a sort, it takes the words with caps and sort that first, then it look at the lower case and sort that after the upper case sort.
How do I make APEX sort case insensitive. I used upper and it sorts nicely but that displays the data uppercase which the user don't want.
The same weirdness is going on for the numbers where 10 comes before 1.
Thanks.
Lloyd