Aloha Again... Thanks so much for the advice given so far. I've downloaded more manuals than I've time to read, but am making a lot of progress on identifying the conversion (DBISAM -> FB) issues.

In DBISAM, there is the ability to indicate that an index is not case sensitive. Thus, "Abc" would be right next to "ABC" rather than far apart in the index, the thus (I believe) optimize a query on the field.

I can't seem to find such an animal in FB. Would something this work:?

Select * from Clients where Upper(Clients.Name) like 'SMITH%'

TIA,
-k-





[Non-text portions of this message have been removed]