String Functions

Function Return Type Description
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.

results matching ""

    No results matching ""