SAP Sybase IQ supports most of the same functions as SQL Anywhere and Adaptive Server Enterprise, with some differences.
Adaptive Server Enterprise supports the USING CHARACTERS | USING BYTES syntax in PatIndex(); SQL Anywhere and SAP Sybase IQ do not.
Adaptive Server Enterprise supports the Reverse() function; SQL Anywhere and SAP Sybase IQ do not.
Adaptive Server Enterprise supports Len() as alternative syntax for Length(); SQL Anywhere does not support this alternative.
Adaptive Server Enterprise supports the Square() and Str_Replace() Microsoft compatibility functions; SQL Anywhere does not.
SAP Sybase IQ supports Str_Replace().
Adaptive Server Enterprise and SQL Anywhere support TSEQUAL() to compare two timestamps for modification time; SAP Sybase IQ does not support TSEQUAL(). (TSEQUAL is not relevant in the SAP Sybase IQ table-level versioning model.)
SAP Sybase IQ supports ROWID(); Adaptive Server Enterprise and SQL Anywhere do not.
SQL Anywhere and SAP Sybase IQ support Cast() in addition to Adaptive Server Enterprise’s Convert() for data type conversions.
SQL Anywhere and SAP Sybase IQ support Lcase() and Ucase() as synonyms of Lower() and Upper(); Adaptive Server Enterprise does not.
SQL Anywhere and SAP Sybase IQ support the Locate() string function; Adaptive Server Enterprise does not.
SQL Anywhere supports the IsDate() and IsNumeric() function to test the ability to convert a string to the respective data type; Adaptive Server Enterprise does not. SAP Sybase IQ supports IsDate(). You can use IsNumeric in SAP Sybase IQ, but CIS functional compensation performance considerations apply.
SQL Anywhere supports the NEWID, STRTOUID, and UUIDTOSTR functions; Adaptive Server Enterprise does not. These are native functions in SAP Sybase IQ, so CIS functional compensation performance considerations do not apply.