This is an old revision of the document!
| SQL Functions | Description | |
|---|---|---|
| CASE | Allows simple IF..THEN..ELSE logic in a select-item. | |
| CAST | Convert an expression to a specific data type. | |
| CHAR_LENGTH | CHARACTER_LENGTH | Return the number of characters in a string. | |
| || (Concatenation) | Concatenate multiple characters strings into a single character string. | |
| CURRENT_DATE | Return the current data from the system clock. | |
| CURRENT_TIME | Return the current time from the system clock. | |
| CURRENT_TIMESTAMP | Return the current timestamp from the system clock. | |
| CURRENT_USER | Return the current Omnidex user. | |
| EXTRACT | Extract an individual field value from a date_class data type field. | |
| LOWER | Convert all characters in a text string to lower case. | |
| POSITION | Return the position of a string within another string. | |
| SUBSTRING | Return a specific part of a string. | |
| SESSION_USER | Return the | current Omnidex user. |
| SYNONYMS | Use synonyms of a word or phrase as qualification criteria. | |
| SYSTEM_USER | Return the current system user. | |
| TRIM | Remove leading and/or trailing “pad” characters from a string. | |
| UPPER | Convert all characters in a text string to upper case. | |
| USER | Return the current Omnidex user. |
Statement