| BTRIM([string] basetext, [optional string] trimtext) |
String |
Trims trimtext from both sides of basetext. If trimtext is omitted then spaces are trimmed. |
| BYTE_SUBSTR([string] giventext, [number] x, [number] y) |
Binary |
Produces the binary representation of a string y characters long derived by starting at position x in the string giventext. y may also be given by the expression LENGTH(giventext), which indicates that you wish to convert every remaining character in giventext. |
| CHAR_LENGTH([string] giventext) |
Integer |
Calculates the length of the string giventext. |
| CONCAT([string] text1, [optional string] text2, [optional string] text3, ...) |
String |
Combines strings. |
| FROM_HEX([string] field) |
Binary |
Returns a binary value for the given hexadecimal string value. |
| ILIKE([string] text1, [regexp_string] text2) |
Boolean |
Returns true if text1 matches the expression provided, and false otherwise. This accepts SQL regular expressions and is case-insensitive. |
| INITCAP([string] giventext) |
String |
Capitalizes the first letter in each word of giventext. |
| "LEFT"([string] giventext, [number] x) |
String |
Returns the x leftmost characters of giventext. Function name must be enclosed in double quotes. |
| LENGTH([string] giventext, [optional literal string] character_encoding |
Integer |
Gives the length of string giventext in the encoding scheme designated by the string character_encoding. If character_encoding is not specified then 'UTF8' is assumed. |
| LOWER([string] giventext) |
String |
Converts the string giventext to all lowercase letters. |
| LPAD([string] basetext, [number] x, [optional string] padtext) |
String |
Prepends padtext to basetext in a way that allows as many characters as possible from padtext given an output string length of x. When x is less than or equal to the length of basetext, only characters from basetext are printed in the output. If padtext is omitted then spaces are prepended. |
| LTRIM([string] basetext, [optional string] trimtext) |
String |
Trims trimtext from the left of basetext. If trimtext is omitted then spaces are trimmed. |
| POSITION([string] sometext IN [string] giventext) |
Integer |
Gives the location of the string sometext in giventext. |
| REGEXP_MATCHES([string] giventext, [string literal] matching) |
Boolean |
Returns true if the regular expression in matching matches the string in giventext. This function accepts Java regular expressions. |
| REGEXP_LIKE([string] giventext, [string literal] matching) |
Boolean |
Returns true if the regular expression in matching matches the string in giventext. This function accepts Java regular expressions. |
| REGEXP_REPLACE([string] basetext. [string] matching, [string] newtext) |
String |
Replaces the patterns in basetext described by the regular expression matching with the string newtext. This function accepts Java regular expressions. |
| REPLACE([string] basetext, [string] text1, [string] text2) |
String |
Replaces text1 with text2 in basetext. |
| REVERSE([string] giventext) |
String |
Reverses giventext. |
| "RIGHT"([string] giventext, [number] x) |
String |
Returns the x rightmost characters of giventext. Function name must be enclosed in double quotes. |
| RPAD([string] basetext, [number] x, [optional string] padtext) |
String |
Appends padtext to basetext in a way that allows as many characters as possible from padtext given an output string length of x. When x is less than or equal to the length of basetext, only characters from basetext are printed in the output. If padtext is omitted then spaces are appended. |
| RTRIM([string] basetext, [optional string] trimtext) |
String |
Trims trimtext from the right of basetext. If trimtext is omitted then spaces are trimmed. |
| SPLIT_PART([string] basetext, [string] splitter, [number] index) |
String |
Splits basetext wherever splitter occurs, and returns the Nth element in this list, where N is given by index. The first element is retrieved by setting index = 1. |
| STRPOS([string] giventext, [string] sometext) |
Integer |
Gives the location of the string sometext in giventext. |
| SUBSTR([string] giventext, [number] x, [optional number] y) |
String |
Returns a y character string derived from giventext that begins at position x. If the number y is omitted then rest of the characters in giventext past position x are returned. |
| TO_HEX([binary] field) |
String |
Returns a hexadecimal value for the given binary value. |
| TRIM(LEADING or TRAILING or BOTH [string] trimtext FROM [string] basetext) |
String |
Trims trimtext from the left side, the right side, or both sides of basetext. |
| UPPER([string] giventext) |
String |
Converts the string giventext to all uppercase letters. |