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