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