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