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.