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 to optimize these if possible.
Adaptive Server Anywhere and Adaptive Server Enterprise do not support Contains().
