Re: Order by with case unsensitive in UNION

>I'm trying to sort datas in an UNION with case unsensitive:
>
>SELECT address1 from A
>UNION
>SELECT address2 from B
>ORDER BY LOWER(1)
>
>but it doesn't work.

There are no ways to do this. You can append sort expression into select list only and
use it in ORDER BY clause

Regards. Valery. Received on Mon Jan 04 1999 - 07:23:54 CST