> But if i use UNICODE_FSS ? any other way ?

I'm afraid there aren't much nice solutions for this.
You could cast your field in your select like this :

SELECT
CAST(t.Name AS varChar(35) CHARACTER SET ISO8859_1) As "Name",
FROM
SomeTable t
ORDER BY
1 COLLATE DU_NL

But it isn't nice as i said.

Regards,
Arno

>
> Thanks,
> Diko
>
> Hi,
>
> Take a look at charactersets and collations for case insensitive sorts.
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase and Firebird
> http://www.interbaseworkbench.com
>
> Upscene Productions
> http://www.upscene.com
>
> "This is an object-oriented system.
> If we change anything, the users object."
>
>
> > Hai All,
> >
> > How i can sorting this data in table :
> >
> > 1 admin
> > 2 ADMIN
> > 3 baby
> > 4 BABY
> >
> > where :
> >
> > 2 ADMIN
> > 1 admin
> > 4 BABY
> > 3 baby
> >
> > ???
> >
> > I have used ORDER BY, but the result :
> >
> > 2 ADMIN
> > 4 BABY
> > 1 admin
> > 3 baby