when i select from my interbase, the sort oder is Upper case first, then lower case, such as Z will be before a.
sort order is A, B, C, D ... Z, a, b, c,..., z.
How can i get the sort result in this order
A, a, B, b, C, c
I am using Interbase here.