Removed FunctionsThe following are the functions that have been removed:
Removed
Description
MOD
This function is no longer necessary. You may use the MOD operator instead with ElevateDB.
LASTAUTOINC
IDENT_CURRENT
These functions are no longer necessary. ElevateDB procedures and functions can retrieve the assigned IDENTITY value for a column using the FETCH statement on a cursor.
These functions are no longer necessary. ElevateDB supports the standard SQL date and time interval types. Please see the Interval Types topic for more information.
Function ChangesThe following are the changes to the functions:
Changed
Description
SUBSTRING
The alternate SUBSTR syntax is now acceptable.
TEXTSEARCH
This function has been changed to the CONTAINS and DOES NOT CONTAIN operators.