SQL functions

Sybase IQ supports most of the same functions as Adaptive Server Anywhere and Adaptive Server Enterprise, with these differences:

Adaptive Server Enterprise supports the USING CHARACTERS | USING BYTES syntax in PatIndex(); Adaptive Server Anywhere and Sybase IQ do not.
Adaptive Server Enterprise supports the Reverse() function; Adaptive Server Anywhere and Sybase IQ do not.
Adaptive Server Enterprise supports Len() as alternative syntax for Length(); Adaptive Server Anywhere does not support this alternative.
Adaptive Server Enterprise supports the Square() and Str_Replace() Microsoft compatibility functions; Adaptive Server Anywhere does not.
Sybase IQ supports Str_Replace().
Adaptive Server Enterprise and Adaptive Server 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 Adaptive Server Anywhere do not.
Adaptive Server Anywhere and Sybase IQ support Cast() in addition to Adaptive Server Enterprise’s Convert() for data type conversions.

Cast() is the ANSI-compliant name.
Adaptive Server Anywhere and Sybase IQ support Lcase() and Ucase() as synonyms of Lower() and Upper(); Adaptive Server Enterprise does not.
Adaptive Server Anywhere and Sybase IQ support the Locate() string function; Adaptive Server Enterprise does not.
Adaptive Server 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.
Adaptive Server Anywhere supports the NEWID, STRTOUID, and UUIDTOSTR functions; Adaptive Server Enterprise does not. You use these functions in Sybase IQ, but CIS functional compensation performance considerations apply.

Some SQL functions, including SOUNDEX and DIFFERENCE string functions, and some date functions operate differently in Sybase IQ and Adaptive Server 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.