Re: Order by with case unsensitive in UNION

From: Douglas Whitacre <whitacre_at_imake.com>
Date: Tue, 5 Jan 1999 12:18:59 -0500
Message-ID: <76thi4$f58@world1.bellatlantic.net>

Not sure if anyone will see this, but I think you have the right idea, just in the wrong place:

Select lower (address1) from A
UNION
Select lower(address2) from B
order by 1

jeff wrote in message <3690C2B5.67E1C0A9_at_nettwerk.com>...
>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 Tue Jan 05 1999 - 11:18:59 CST