The full-text search control uses the SQL “like” operator to perform its search. Your application first checks to see if the collation specified for the database is case insensitive. If the collation is case insensitive, then the database handles the comparison without regard to the case.
If the collation is case sensitive, then the search and comparison strings are converted to uppercase for the comparison. For example, if you have three searchable columns (c1, c2, c3) in your database table and the application user enters the word "House" to search, the search control will execute the following SQL query:
UPPER(C1) LIKE '%HOUSE%' AND
UPPER(C2) LIKE '%HOUSE%' AND
UPPER(C3) LIKE '%HOUSE%' AND
No syntax for more complex searches is provided by the Iron Speed search control, such as conjunctions (ANDs) and disjunctions (ORs). However, you can create multiple search controls and associate each one of them to one or more fields. For example, one search control can be provided to “Search by Account Number” and another to “Search by Name or Company Name”.