Re: Order by with case unsensitive in UNION

Couldn't you create a view and then query the view?

Valery Tsekhmister wrote:
>
> >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:31:33 CST