Re: Sort Order

From: Kingsley Sawyers <no_at_way.im.telling>
Date: Mon, 26 Jul 1999 15:39:44 +0100
Message-ID: <7nhrt9$npb$1@lure.pipex.net>

Try

SELECT...
FROM...
WHERE...

ORDER BY UPPER(<text column>);

i.e. sort the results by the uppercase equivalent of your colunm entries.

Julian Cowking wrote in message <7nhnea$ceq$1_at_starburst.uk.insnet.net>...
>Hi,
>
>Is there a way to change the Oracle Sort Order?
>I want Oracle to be case INSENSITIVE. At the moment it is case sensitive.
>Any way around this?
>
>Cheers
>
>Julian
>
>
Received on Mon Jul 26 1999 - 09:39:44 CDT