substring matching in filters, and partial compare (d3)

- Can anyone tell me whether it is possible to test in a DBTable filter
whether a string field contains a certain substring? I know how to do it
in a SQL query (field like "*substring*"). I also know how to to it in a
OnFilterRecord event, but I would like to do it in the filter property
(something like StringFieldA is "*substring*").
- Can anyone explain to me what the "foNoPartialCompare" does in the
filter options property? The documentation does not explain it, and in
the example in delphi I do not see any effect.

Thanks

Frans (frans...@IAEhv.nl