How to filter the data by Partial match anywhere

Jay Cheng

Delphi Developer

Sun, 16 Nov 2003 03:20:12 GMT

How to filter the data by Partial match anywhere

Hello,

I use TTable and want to filter the data by Partial match anywhere in
the string data, looks like '*ab*'. However, only 'ab*' works. Is there
any way to get around? Your help would be greatly appreciated.

Jay.

Frederic Gelina

Delphi Developer

Sun, 16 Nov 2003 03:28:54 GMT

Re:How to filter the data by Partial match anywhere

Use the onFilter event of the TTable for this king of filtering.
Why not use a Tquery instead?

Jay Chen

Delphi Developer

Sun, 16 Nov 2003 03:59:37 GMT

Re:How to filter the data by Partial match anywhere

I found the way. Thanks.

Jay.

Quote

Jay Cheng wrote:
> Hello,

> I use TTable and want to filter the data by Partial match anywhere in
> the string data, looks like '*ab*'. However, only 'ab*' works. Is there
> any way to get around? Your help would be greatly appreciated.

> Jay.

Team

Delphi Developer

Sun, 16 Nov 2003 07:39:51 GMT

Re:How to filter the data by Partial match anywhere

Use an OnFilterRecord event handler or a query with the SQL LIKE operator.

--
Bill

Other Threads

1. Partial match anywhere Filter in the Filter property

2. searching text fields for partial matches anywhere in field

3. substring matching in filters, and partial compare (d3)

4. Partial filter strings Filters ?

5. TTable.filter - How to set a partial filter

6. SQL: Partial matches for query

7. Search records for partial matches

8. Partial Text Match

9. How do you find a partial match in a blob field

10. Partial matches