I'm looking for a way to do case insensitive order by's..
Something as simple as select * from clients order by upper(last_name) would
be ideal, however, IB/FB don't like this.
I've gotten the following to work: select upper(last_name) as blah,
clients.* from clients order by 1
However, this seems like a hack to me, and that there's probably a better
way to do it (At least, I'm hoping there is :)).
I checked back through the archives, and the discussion around christmas of
2001, re case insensitive indexes was about as close as I could come, but
that's not what I want, really, as I only need case insensitivity for one
operation (A list box containing a list of records to be selected, ordered
by last name.. Technically this is user entry error, however how many users
are going to do everything the right way every time :)).
Any ideas?

- Jason