this solvs the problem for me:
with dm_main.qrySelTarif do
begin
Close;
case abs ( OrderingItemNo ) of
1 : begin
// Suche nach Nummer
SQLWhere.Clear;
SQLWhere.Add ( 'WHERE UPPER(TA_NR) STARTING WITH ' + QuotedStr
ansiUpperCase (editSuche.Text ) ) );
end;
2 : begin
// Suche nach Text1
SQLWhere.Clear;
SQLWhere.Add ( 'WHERE UPPER(TA_TEXT1) STARTING WITH ' + QuotedStr
ansiUpperCase ( editSuche.Text ) ) );
end;
3 : begin
// Suche nach Text1
SQLWhere.Clear;
SQLWhere.Add ( 'WHERE UPPER(TA_TEXT2) STARTING WITH ' + QuotedStr
ansiUpperCase ( editSuche.Text ) ) );
end;
4 : begin
// Suche nach Text1
SQLWhere.Clear;
SQLWhere.Add ( 'WHERE UPPER(TA_MATCH) STARTING WITH ' + QuotedStr
ansiUpperCase ( editSuche.Text ) ) );
end;
end;

perhaps not a prof way :-)
Greetings Christian

----- Original Message -----
From: Riho-Rene Ellermaa <r.ellermaa@...>
To: IBObject (E-mail) <IBObjects@yahoogroups.com>
Sent: Wednesday, February 07, 2001 10:53 AM
Subject: [IBO] Sorting


> Hi!
> I have simple query "select name, address from company".
> In OrderingItems I have "Name=Name;Name desc"
> In ColumnAttributes I set Name="Case Insensitive"
>
> But when I look at the data in grid the names are sorted:
> IBM
> Shell
> hansabank
>
> The small letters are sorted after all big letters.
> How can I make in IBO the sorting case insensitive?
>
>
> Riho-Rene Ellermaa
> senior programmer
> Hansabank
>
>
>
>