The full-text search control uses the SQL “like” operator to perform its search. The search performed is case insensitive, meaning upper- and lower-case search strings will return the same result set.
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 (and’s) and disjunctions (or’s).
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”.