Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: case-insensitive sort
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 ...
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