SQL Function Support

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 Sybase IQ do not.
Adaptive Server Enterprise supports the Reverse() function; SQL Anywhere and 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.
Sybase IQ supports Str_Replace().
Adaptive Server Enterprise and SQL Anywhere support TSEQUAL() to compare two timestamps for modification time; Sybase IQ does not support TSEQUAL(). (TSEQUAL is not relevant in the Sybase IQ table-level versioning model.)
Sybase IQ supports ROWID(); Adaptive Server Enterprise and SQL Anywhere do not.
SQL Anywhere and Sybase IQ support Cast() in addition to Adaptive Server EnterpriseAdaptive Server Enterprise’s Convert() for data type conversions.

Note: Cast() is the ANSI-compliant name.
SQL Anywhere and Sybase IQ support Lcase() and Ucase() as synonyms of Lower() and Upper(); Adaptive Server Enterprise does not.
SQL Anywhere and 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. Sybase IQ supports IsDate(). You can use IsNumeric in 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 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 Sybase IQ and SQL Anywhere. The Sybase IQ database option ASE_FUNCTION_BEHAVIOR specifies that output of some of the Sybase IQ data type conversion functions, including HEXTOINT and INTTOHEX, is consistent with the output of Adaptive Server Enterprise functions.