Specifies whether or not partial comparisons are permitted when filtering records.

Delphi syntax:

property FilterOptions: TFilterOptions;

C++ syntax:

__property TFilterOptions FilterOptions;

Description

Set FilterOptions to specify whether or not partial comparisons for matching filter conditions is allowed. The filter option value foCaseInsensitive is without function, because TurboDB works with table column collations that determine the case sensitivity.

When a string in a filter ends with an asterisk (*), it can be used to match partial strings. To disable matching of partial strings and to treat the asterisk as a literal character in string comparisons, set FilterOptions to include foNoPartialCompare.