Bean Software Search Control Documentation   
 
 
     




enuWhereToSearch Enumeration


Description:
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.

Example: 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.