Jason Wharton wrote:

>
> Is it possible to allow the use of the UPPER( ) function in the order by
> clause for case insensitive sorts? I noticed that right now this is not
> possible but it sure would solve some problems for me if we could.
>
> For now I use a mirror/surrogate column that is trigger maintained to be the
> UPPER( ) equivalent but it is a pain to have to do that even though IBO
> abstracts it all into a very simple setting...

There's another workaround here, as well:

SELECT
FOO, UPPER(FOO)
FROM
BAR
ORDER BY
2;

-Craig

--
Craig Stuntz Vertex Systems Corporation
Senior Developer http://www.vertexsoftware.com

Delphi/InterBase weblog: http://delphi.weblogs.com
_______________________________________________
Ib-architect mailing list
Ib-architect@...
http://mers.com/mailman/listinfo/ib-architect