This is an old revision of the document!
Omnidex SQL: Functions
String Functions
| Function | Syntax | Description | | |
| CHAR[ACTER]_LENGTH | char_length(char_expr) | Return the number of characters in a character expression. | | |
| LOWER | LOWER(char_expr) | Convert all characters in a character expression to lower case. | | |
| POSITION | POSITION(search_expr IN target_expr) | Return the position of a character expression within another character expression. | | |
| SUBSTRING | SUBSTRING(char_expr FROM pos FOR len) | Return a specific part of a character expression starting at FROM position FOR length. | | |
| TRIM | TRIM(['char' FROM] column) | Remove leading and/or trailing spaces or characters from a character expression. | | |
| UPPER | UPPER(column) | Convert all characters in a character expression to upper case. | | |
| \|\| (Concatenation) | char_expr \ | \ | char_expr | Concatenate multiple character expressions into a single character expression. |
| $LJ | $LJ(char_expr) | Left justify a character expression eliminating leading white space. | | |
| $LPAD | $LPAD(char_expr, len [, pad_char ]) | Add leading 'pad' characters to a character expression. | | |
| $PROPER | | Shift the first letter of each word in a character expression to upper case and all other letters to lower case. | | |
| $RJ | $RJ(char_expr) | Right justify a character expression eliminating trailing white space. | | |
| $RPAD | $RPAD(char_expr, len [, pad_char ]) | Add trailing 'pad' characters to a character expression. | | |