Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: case-insensitive sort

Re: case-insensitive sort

From: David Fitzjarrell <oratune_at_msn.com>
Date: 13 Jan 2003 08:24:57 -0800
Message-ID: <32d39fb1.0301130824.40659c2b@posting.google.com>


Using SQL Server comes to mind ...

Your other option is to convert the values to either all upper-case or all lower-case and sort (order) on the converted column:

select ..., ..., ...
from ...
where ...

order by upper(column_name)

This, of course, is not as fast as having the associated function-based index in place, but it does work.

You could, as an application modification, store the case-insensitive values in another column, index that, then perform your order by operations. Of course, that requires change control and an outage, something you may be willing to do.

David Fitzjarrell

"Andrey Voronov" <avoronov_at_diasoft.ru> wrote in message news:<avtmo8$23jf$1_at_gavrilo.mtu.ru>...
> How I can implement case-insensitive sort without use function-based index?
Received on Mon Jan 13 2003 - 10:24:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US