CONTAINS
The CONTAINS function returns the rows from the table with columns that contains the search string specified in the argument.
Syntax
CONTAINS(column_name, search_expression)
Example
SELECT *
from /shared/examples/ds_inventory/tutorial/employees
where CONTAINS(firstname, 'Jo')
The above query returns all the rows that has the string “Jo” as part of the first name column.