SQL functions

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 IQ do not.

• Adaptive Server Enterprise supports the Reverse() function; Adaptive Server Anywhere and IQ do not.

• Adaptive Server Enterprise supports Len() as alternative syntax for Length(); Adaptive Server Anywhere and IQ do not support this alternative.

• Adaptive Server Enterprise supports the Square() and Str_Replace() Microsoft compatibility functions; Adaptive Server Anywhere and IQ do not.

• Adaptive Server Enterprise and Adaptive Server Anywhere support TSEQUAL() to compare two timestamps for modification time; IQ does not support TSEQUAL(). (TSEQUAL is not relevant in the IQ table level versioning model.)

• IQ supports ROWID(); Adaptive Server Enterprise and Adaptive Server Anywhere do not.

• Adaptive Server Anywhere and 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 IQ support Lcase() and Ucase() as synonyms of Lower() and Upper(); Adaptive Server Enterprise does not.

• Adaptive Server Anywhere and 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. IQ supports IsDate(). You can use IsNumeric in 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 IQ, but CIS functional compensation performance considerations apply.