I am trying to ensure that when I do a SORT BY I get back the results in
normal sorted order instead of case-sensitive order. The WHERE clause
contains a LIKE '%..%' so I cannot use UPPER here in a way that does
what I want.
e.g. , given
A, B, b, a
as data, the normal SORT BY behavior returns
a
b
A
B
How do I make it return
a
A
b
B
instead?
./patrick