SQL Function Support

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.

Note: Cast() is the ANSI-compliant name.
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.

Note: Some SQL functions, including SOUNDEX and DIFFERENCE string functions, and some date functions operate differently in SAP Sybase IQ and SQL Anywhere. The SAP Sybase IQ database option ASE_FUNCTION_BEHAVIOR specifies that output of some of the SAP Sybase IQ data type conversion functions, including HEXTOINT and INTTOHEX, is consistent with the output of Adaptive Server Enterprise functions.