Thanks, that almost works: ÄOÖÜ instead of OÄÖÜ, but one cannot be choosy :)

Riho-Rene Ellermaa
senior programmer
Hansabank

>
> > I need ABCDEF...TUVOÄÖÜXY
>
> Hmm, ok this is your definition for sorting. For German AÄBCM
> is suitable,
> because Ä is interpreted as AE and so it is before B. The same sorting
> order is used in a German dictionary.
>
> I don't know if there is a character set/collation
> combination, which really
> fulfill your needs. One thing you could do though.
>
> select upper(your_pxw_intl850_field) from yourtable order by 1 collate
> win1252
>
> Regards,
> Thomas Steinmaurer
> IB LogManager 2.0 - The Logging/Auditing Tool for Interbase
> and Firebird
> http://www.iblogmanager.com
>
>