| |
|
|
|
|
enuWhereToSearch Enumeration
Represents enumeration used for WhereToSearch property. It is used with SQLSyntax with LIKE keyword only, including StandardANSISQL, MSAccessSQL, MSSQLWithLikeKeyword, MySQLWithLikeKeyword and OracleWithLikeKeyword SQL syntax. This property has no affect in full text searching syntax, including MSSQLFullTextSearch, MySQLFullTextSearch and OracleText.
Member Name |
Description |
BeginningOfRecord |
Search only records that begins with search term. |
EndOfRecord |
Search only records that ends with search term. |
MiddleOfRecord |
Search terms anywhere in the column. |
ExactRecord |
Find only record which are the same as the search term. |
If Text property is set to "apple" and WhereToSearch is set to enuWhereToSearch.BeginningOfRecord, SQL query will return rows that begins with a word apple. If Text property is "*apple*" and MultipleWildCard is set to Asterisk, control will search word apple anywhere in the record.
|
|
|
| |