FilterSyms Fields |
The FilterSyms type exposes the following members.
Fields| Name | Description | |
|---|---|---|
  | And | An AND conjunction. |
| Between | A BETWEEN condition which expects an AND conjunction separating two range delimiter values. |
| Contains | Specifies that the value must be contained in the searched content. Applies to strings only. |
| DoesNotContain | Specifies that the value must NOT be contained in the searched content. Applies to strings only. |
| DoesNotInclude |
This is the DoesNotInclude item used with BitFlags filtering, currently
for obtaining text only and not for invoking a filtering operation.
|
| DoesNotStartWith | Specifies that the value must NOT start the searched content. Applies to strings only. |
| FTS | Filters for Contains using full-text-search index. |
| Includes | |
| IsNotNull | Filters for non-null values only. |
| IsNull | Filters for null values only. |
| Length | Filters on string length. |
| Like | Filters for matches using the SQL "LIKE" keyword allowing use of SQL "%" and "?" wildcards. |
| Not | Negation. |
| NotLike | Filters for non-matches using the SQL "LIKE" keyword allowing use of SQL "%" and "?" wildcards. |
| Or | An OR conjunction. |
| SoundsLike | Specifies that the value be phonetically similar to the searched content (using SOUNDEX). Applies to strings only. |
| StartsWith | Specifies that the value must start the searched content. Applies to strings only. |
See Also