Am Son, 2003-08-10 um 15.23 schrieb Jason Davis:
> I can't use ORDER BY lower(col1) in my original and more complex query as
> the column is the result of a function.
If col1 is a function then try
ORDER BY <here_the_function_again_to_avoid_alias>
Of course this is ugly and slow, but if you find no other way at all ...
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de