> I think it supposed to be case sensitive right ? It should
> search for different record when "S" and "s" is typed.
> Anyway, I tried your suggestion and doesn't work.

Sorry about that, I misunderstood. I think the problem you are
experiencing is actually to do with Windows. IBO uses AnsiCompareStr
to do the case sensitive comparison and the following details are
available in the online help for that function...

- - - Start VCL Online Help - - -
Most Windows locales consider lowercase characters to be less than the
corresponding uppercase characters. This is in contrast to ASCII
order, in which lowercase characters are greater than uppercase
characters. Thus,

AnsiCompareStr('a','A')
returns a value less than zero, while
CompareStr('a','A')
returns a value greater than zero.
- - - End VCL Online Help - - -


You have a few different options...

1. You own comparison...

TIB_Connection provides two event handlers...
OnCustomCompareText - perform custom case insensitive comparison
and
OnCustomCompareStr - perform custom case sensitive comparison


2. Change the locale of the database to match Windows.


3. Stop using case insensitive searching - although there are still
minor problems with the Windows locale - such as the underscore ('_')
character.


HTH

Geoff Worboys
Telesis Computing