Using full text search, you can search for terms, prefixes, or phrases (sequences of terms). You can also combine multiple terms, phrases, or prefixes into Boolean expressions, or use proximity searches to require that expressions appear near to each other.
Perform a full text search using a CONTAINS clause in either a WHERE clause, or a FROM clause of a SELECT statement.
The SQL Anywhere documentation provides full text search examples. Not all of these examples apply to Sybase IQ. For example, Sybase IQ does not support text searches that are part of the IF search condition.