How can avoid sort If I want to sort the way, let's say Germans expect the sort order?

Hi,

The problem is I want to access and sort my data the following way:

COLUMN
A
(special language character)

B
C
...
U
(special language character)

and I want to avoid a sort for where clauses like

column >= :field
order by column;

index exists on column and I want Oracle to build it the same way as Germans would read the alphabet.

Can I do this and avoid a sort (index has to bew built this way) if I want to have a different sort order than US standard?

Thanks,

Niklas Iveslatt Received on Tue Nov 03 1998 - 12:07:28 CST