WHERE clause differs in support for the CONTAINS predicate, and treatment of trailing white space in the LIKE predicate.
IQ supports the Contains() predicate for word searches in character data (similar to Contains in MS SQL Server and Verity). IQ uses WORD indexes to optimize these if possible.
Adaptive Server Anywhere and Adaptive Server Enterprise do not support Contains().
