The FairCom DB SQL CONTAINS predicate is an extension to the SQL standard providing search capabilities for LONG character and binary data. This predicate can be used inside of a WHERE, HAVING, or JOIN statement.
Syntax
column_name [ NOT ] CONTAINS 'string'
Limitations
column_name must be one of the following data types: Fixed or varying-length character type, LVARCHAR, BINARY, VARBINARY, or LVARBINARY.
Unlike the LIKE clause, the wildcard characters ‘%’ and ‘_’ are not allowed with CONTAINS.
CONTAINS does not take advantage of indexes to perform the search.
The CONTAINS predicate is an extension to the SQL standard providing search capabilities for LVARBINARY and LVARCHAR data types.
