Partial strings search in Delphi

[ukusa]

Using Delphi 5... IS there any way to locate for example "myt" in "Smyth" when using a filter or locate? Delphi project is using Paradox tables and filter only allows partial provided that you start from the first letter eg: "Smy*". * is to tell Delphi to ignore the rest when compaing. The users of of Paradox equal like to put in bits of surnames regardless where they are in the name. The condition to this is to be able to FIND NEXT or PREVIOUS using that ability.

Thanks
Allen Crisell

 

[TealWren]

You could use a query, and use the like operator -
select * from table where field like '%myt%'

Good luck!
TealWren

 

[Nezric]

Locate will allow you to do a partial match on the string. It will only work if the string you are looking for is the beginning of the key.

using [loPartialKey] as an locate option should allow you to find the first match. You second option is to make your own OnFilter event to determine if the record matchs