Dremio Cloud
Dremio Software
 
On this page

    String

    Function Name Description
    ASCII Returns the ASCII code for the first character of a string. If the string is empty, 0 is returned.
    BASE64 Returns the Base64 encoding of a binary string.
    BTRIM Trims leading and trailing characters from a string.
    CHARACTER_LENGTH Returns the length of an input string.
    CHAR_LENGTH Returns the character length of the input string
    CHR Converts a Unicode code point into the character that matches the input Unicode character. If an invalid code point is specified, an empty string is returned.
    COL_LIKE Tests whether an expression column matches a pattern column. Comparisons are case-sensitive.
    CONCAT Concatenates two or more strings. NULL values are ignored.
    CONCAT_WS Concatenate with separator. Returns a string resulting from the joining of two or more string values in an end-to-end manner. Uses the first argument as the separator between each string.
    ENDS_WITH Returns whether a string ends with another string. The comparison is case-sensitive.
    FROM_HEX Returns a binary value for the given hexadecimal string
    HEX Returns the hexadecimal encoding of an expression.
    ILIKE Tests whether an expression matches a pattern. The comparison is case-insensitive.
    INITCAP Returns the input string with the first letter of each word in uppercase and the subsequent letters in the word are in lowercase).
    INSTR Returns the position of the first occurrence of a string when it is contained in another string. If no such occurrence is found, a zero is returned. The comparison is case-sensitive.
    IS_UTF8 Returns whether an expression is valid UTF-8
    LCASE Returns the input expression with all the characters converted to lowercase.
    LEFT Returns the left-most substring. The function name must be enclosed in double quotes ("LEFT").
    LENGTH Returns the length of an input string. If the character encoding isn’t specified, it assumes to UTF8.
    LEVENSHTEIN Computes the Levenshtein distance between two input expressions.
    LIKE Tests whether an expression matches one or more patterns. Comparisons are case-sensitive.
    LOCATE Searches for the first occurrence of the first argument in the second argument and if found, returns the position the of the first argument in the second argument. The first character in a string is position 1. Returns 0 if the substring isn’t found in the expression.
    LOWER Returns the input expression with all the characters converted to lowercase.
    LPAD Left pads a string with spaces or specified characters to reach the number of chracters specified as a parameter.
    LTRIM Removes leading spaces or characters from a string.
    MASK Returns a masked version of a string.
    MASK_FIRST_N Returns a masked version of a string with the first num_chars characters masked. By default, if you do not provide a mask value, the first four characters are masked.
    MASK_HASH Returns a consistent hash value based on the input string. This function returns NULL for non-string types.
    MASK_LAST_N Returns a masked version of a string with the last num_chars characters masked. By default, if you do not provide a mask value, the last four characters are masked.
    MASK_SHOW_FIRST_N Returns a masked version of a string with the first num_chars characters unmasked. By default, if you do not provide a value, the first four characters are shown.
    MASK_SHOW_LAST_N Returns a masked version of a string with the last num_chars characters unmasked. By default, if you do not provide a value, the last four characters are shown.
    OCTET_LENGTH Returns the length of the string in bytes.
    POSITION Returns the position of the first occurrence of a substring within another string
    QUOTE Returns a result that can be used as a properly escaped data value in a SQL statement.
    REGEXP_EXTRACT Extracts the first string in expression that matches the REGEXP expression and corresponds to the REGEX group index.
    REGEXP_LIKE Returns true when the specified regular expression matches values in a column. Otherwise, returns false.
    REGEXP_MATCHES Returns true when the specified regular expression matches values in a column. Otherwise, returns false.
    REGEXP_REPLACE Finds strings that match the given regular expression and replaces the strings with the given string.
    REGEXP_SPLIT Splits an input string by using a regular expression according to a keyword and an integer value.
    REPEAT Builds a string by repeating the input for the specified number of times
    REPEATSTR Repeats the given string n times.
    REPLACE Removes all occurrences of a specified substring and replaces them with another string.
    REVERSE Reverses the order of characters in a string.
    RIGHT Returns the right-most substring. The function name must be enclosed in double quotes (“RIGHT”).
    RPAD Right pads a string with spaces or specified characters to reach the number of chracters specified as a parameter.
    RTRIM Removes trailing spaces or characters from a string.
    SIMILAR_TO Tests whether the entire expression matches a pattern.
    SOUNDEX Returns a string that contains a phonetic representation of the input string.
    SPLIT_PART Splits a given string at a specified character and returns the requested part.
    STARTS_WITH Returns whether a string starts with another string. The comparison is case-sensitive.
    STRPOS Searches for the first occurence of the substring in the given expression and returns the position of where the substring begins. Searching binary values is also supported.
    SUBSTRING Returns the portion of the string from the specified base expression starting at the specified chracters.
    SUBSTRING_INDEX Returns a substring of an expression before the specified number of delimiter occurs.
    TOASCII Converts a string that is encoded in the specified character set to UTF-8.
    TO_HEX Returns a hexadecimal string for the given binary value.
    TRANSLATE Translates the base expression from the source characters/expression to the target characters/expression.
    TRIM Removes leading, trailing, or both spaces or characters from a string.
    UCASE Returns the input expression with all the characters converted to uppercase.
    UNBASE64 Decodes a Base64-encoded string.
    UNHEX Converts the hexadecimal number into the bytes represented by a number.
    UPPER Returns the input expression with all the characters converted to uppercase.