""Jason Frey"" <jason_frey@...> wrote in message
news:000701c1a366$fe4067f0$3500a8c0@jason...

> 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

Case insensitive collations by Dave Schnepper will work if you force the
desired collation in the ORDER BY clause, provided that the collation is
available for the charset used in the column. Whether you can load the right
collation DLL is another issue.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing