SQL Functions
Allows simple IF..THEN..ELSE logic in a select-item.
Convert an expression to a specific datatype.
Return the number of characters in a string.
Concatenate multiple characters strings into a single character
string.
Return the current data from the system clock.
Return the current time from the system clock.
Return the current timestamp from the system clock.
Return the current Omnidex user.
Extract an individual field value from a date_class datatype
field.
Convert all characters in a text string to lower case.
Return the position of a string within another string.
Return a specific part of a string.
Return the current Omnidex user.
Return the current system user.
Remove leading and/or trailing "pad" characters
from a string.
Convert all characters in a text string to upper case.
Return the current Omnidex user.
top
Extended Functions
Return the length of a column as defined in the environment
catalog.
Convert a scalar expression from one datatype to another.
Return the current row number.
Execute an external user-defined function.
Specify a return value for columns containing null values.
Left justify a string by eliminating leading white space.
Add leading "PAD" characters to a string.
Return "n modulus y" (remainder).
Shift the first letter of each word in a string to upper
case and all other letters to lower case.
Return a pseudo-random number.
Right justify a string by eliminating trailing white space
and inserting leading spaces as needed.
Round a numerical value to the specified number of decimal
places.
Add trailing "PAD" characters to a string.
Return the Soundex equivalent to a character string.
Return a numeric expression truncated to a specified number
of digits to the right of the decimal point.
top
|