The WHERE clause differs between Adaptive Server Enterprise, SQL Anywhere, and Sybase IQ 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().