String Functions

This section provides reference information for the string-related functions in PlaidCloud Lakehouse.

String Manipulation:

String Information:

Case Conversion:

Regular Expressions:

Encoding and Decoding:

Miscellaneous:

ASCII

Learn how to use the ASCII string function in PlaidCloud Lakehouse. Returns the numeric value of the leftmost character of the string str. Includes syntax...

BIN

Learn how to use the BIN string function in PlaidCloud Lakehouse. Returns a string representation of the binary value of N. Includes syntax and examples.

BIT_LENGTH

Learn how to use the BIT_LENGTH string function in PlaidCloud Lakehouse. Return the length of a string in bits. Includes syntax and examples.

CHAR

Learn how to use the CHAR string function in PlaidCloud Lakehouse. Return the character for each integer passed. Includes syntax and examples.

CHAR_LENGTH

Learn how to use CHAR_LENGTH in PlaidCloud Lakehouse. Alias for the LENGTH string function. Includes detailed syntax, examples, and usage reference.

CHARACTER_LENGTH

Learn how to use CHARACTER_LENGTH in PlaidCloud Lakehouse. Alias for the LENGTH string function. Includes detailed syntax, examples, and usage reference.

CONCAT

Learn how to use the CONCAT string function in PlaidCloud Lakehouse. Returns the string that results from concatenating the arguments. With syntax and examples.

CONCAT_WS

Learn how to use the CONCAT_WS string function in PlaidCloud Lakehouse. CONCAT_WS() stands for Concatenate With Separator and is a special form of CONCAT().

FROM_BASE64

Learn how to use the FROM_BASE64 string function in PlaidCloud Lakehouse. Takes a string encoded with the base-64 encoded rules nd returns the decoded...

FROM_HEX

Learn how to use FROM_HEX in PlaidCloud Lakehouse. Alias for the UNHEX string function. Includes detailed syntax, examples, and usage reference.

HEX

Learn how to use HEX in PlaidCloud Lakehouse. Alias for the TO_HEX string function. Includes detailed syntax, examples, and usage reference.

INSERT

Learn how to use the INSERT string function in PlaidCloud Lakehouse. Returns the string str, with the substring beginning at position pos and len characters...

INSTR

Learn how to use the INSTR string function in PlaidCloud Lakehouse. Returns the position of the first occurrence of substring substr in string str.

JARO_WINKLER

Learn how to use the JARO_WINKLER string function in PlaidCloud Lakehouse. Calculates the Jaro-Winkler distance between two strings. With syntax and examples.

LCASE

Learn how to use LCASE in PlaidCloud Lakehouse. Alias for the LOWER string function. Includes detailed syntax, examples, and usage reference.

LEFT

Learn how to use the LEFT string function in PlaidCloud Lakehouse. Returns the leftmost len characters from the string str, or NULL if any argument is NULL.

LENGTH

Learn how to use the LENGTH string function in PlaidCloud Lakehouse. Returns the length of a given input string or binary value. Includes syntax and examples.

LENGTH_UTF8

Learn how to use LENGTH_UTF8 in PlaidCloud Lakehouse. Alias for the LENGTH string function. Includes detailed syntax, examples, and usage reference.

LIKE

Learn how to use the LIKE string function in PlaidCloud Lakehouse. Pattern matching using an SQL pattern. Includes usage and syntax details.

LOCATE

Learn how to use the LOCATE string function in PlaidCloud Lakehouse. The first syntax returns the position of the first occurrence of substring substr in...

LOWER

Learn how to use the LOWER string function in PlaidCloud Lakehouse. Returns a string with all characters changed to lowercase. Includes syntax and examples.

LPAD

Learn how to use the LPAD string function in PlaidCloud Lakehouse. Returns the string str, left-padded with the string padstr to a length of len characters.

LTRIM

Learn how to use the LTRIM string function in PlaidCloud Lakehouse. Removes all occurrences of any character present in the specified trim string from the...

MID

Learn how to use MID in PlaidCloud Lakehouse. Alias for the SUBSTR string function. Includes detailed syntax, examples, and usage reference.

NOT LIKE

Learn how to use the NOT LIKE string function in PlaidCloud Lakehouse. Pattern not matching using an SQL pattern. Includes syntax and examples.

NOT REGEXP

Learn how to use the NOT REGEXP string function in PlaidCloud Lakehouse. Returns 1 if the string expr doesn't match the regular expression specified by the...

NOT RLIKE

Learn how to use the NOT RLIKE string function in PlaidCloud Lakehouse. Returns 1 if the string expr doesn't match the regular expression specified by the...

OCT

Learn how to use the OCT string function in PlaidCloud Lakehouse. Returns a string representation of the octal value of N. Includes syntax and examples.

OCTET_LENGTH

Learn how to use the OCTET_LENGTH string function in PlaidCloud Lakehouse. OCTET_LENGTH() is a synonym for LENGTH(). Includes syntax and examples.

ORD

Learn how to use the ORD string function in PlaidCloud Lakehouse. If the leftmost character is not a multibyte character, ORD() returns the same value as...

POSITION

Learn how to use the POSITION string function in PlaidCloud Lakehouse. POSITION(substr IN str) is a synonym for LOCATE(substr,str). With syntax and examples.

QUOTE

Learn how to use the QUOTE string function in PlaidCloud Lakehouse. Quotes a string to produce a result that can be used as a properly escaped data value in...

REGEXP

Learn how to use the REGEXP string function in PlaidCloud Lakehouse. Returns true if the string matches the regular expression specified by the...

REGEXP_INSTR

Learn how to use the REGEXP_INSTR string function in PlaidCloud Lakehouse. Returns the starting index of the substring of the string expr that matches the...

REGEXP_LIKE

Learn how to use the REGEXP_LIKE string function in PlaidCloud Lakehouse. REGEXP_LIKE function is used to check that whether the string matches the regular...

REGEXP_REPLACE

Learn how to use the REGEXP_REPLACE string function in PlaidCloud Lakehouse. Replaces occurrences in the string expr that match the regular expression...

REGEXP_SUBSTR

Learn how to use the REGEXP_SUBSTR string function in PlaidCloud Lakehouse. Returns the substring of the string expr that matches the regular expression...

REPEAT

Learn how to use the REPEAT string function in PlaidCloud Lakehouse. Returns a string consisting of the string str repeated count times. Includes syntax and...

REPLACE

Learn how to use the REPLACE string function in PlaidCloud Lakehouse. Returns the string str with all occurrences of the string from_str replaced by the...

REVERSE

Learn how to use the REVERSE string function in PlaidCloud Lakehouse. Returns the string str with the order of the characters reversed. Includes syntax and...

RIGHT

Learn how to use the RIGHT string function in PlaidCloud Lakehouse. Returns the rightmost len characters from the string str, or NULL if any argument is NULL.

RLIKE

Learn how to use RLIKE in PlaidCloud Lakehouse. Alias for the REGEXP string function. Includes detailed syntax, examples, and usage reference.

RPAD

Learn how to use the RPAD string function in PlaidCloud Lakehouse. Returns the string str, right-padded with the string padstr to a length of len characters.

RTRIM

Learn how to use the RTRIM string function in PlaidCloud Lakehouse. Removes all occurrences of any character present in the specified trim string from the...

SOUNDEX

Learn how to use the SOUNDEX string function in PlaidCloud Lakehouse. Generates the Soundex code for a string. Includes syntax and examples.

SOUNDS LIKE

Learn how to use the SOUNDS LIKE string function in PlaidCloud Lakehouse. Compares the pronunciation of two strings by their Soundex codes. Includes syntax...

SPACE

Learn how to use the SPACE string function in PlaidCloud Lakehouse. Returns a string consisting of N blank space characters. Includes syntax and examples.

SPLIT

Learn how to use the SPLIT string function in PlaidCloud Lakehouse. Splits a string using a specified delimiter and returns the resulting parts as an array.

SPLIT_PART

Learn how to use the SPLIT_PART string function in PlaidCloud Lakehouse. Splits a string using a specified delimiter and returns the specified part.

STRCMP

Learn how to use the STRCMP string function in PlaidCloud Lakehouse. Returns 0 if the strings are the same, -1 if the first argument is smaller than the...

SUBSTR

Learn how to use the SUBSTR string function in PlaidCloud Lakehouse. Extracts a string containing a specific number of characters from a particular position...

SUBSTRING

Learn how to use SUBSTRING in PlaidCloud Lakehouse. Alias for the SUBSTR string function. Includes detailed syntax, examples, and usage reference.

TO_BASE64

Learn how to use the TO_BASE64 string function in PlaidCloud Lakehouse. Converts the string argument to base-64 encoded form and returns the result as a...

TRANSLATE

Learn how to use the TRANSLATE string function in PlaidCloud Lakehouse. Transforms a given string by replacing specific characters with corresponding...

TRIM

Learn how to use the TRIM string function in PlaidCloud Lakehouse. Returns the string without leading or trailing occurrences of the specified remove string.

TRIM_BOTH

Learn how to use the TRIM_BOTH string function in PlaidCloud Lakehouse. Removes all occurrences of the specified trim string from the beginning, end, or...

TRIM_LEADING

Learn how to use the TRIM_LEADING string function in PlaidCloud Lakehouse. Removes all occurrences of the specified trim string from the beginning of the...

TRIM_TRAILING

Learn how to use the TRIM_TRAILING string function in PlaidCloud Lakehouse. Removes all occurrences of the specified trim string from the end of the string.

UCASE

Learn how to use UCASE in PlaidCloud Lakehouse. Alias for the UPPER string function. Includes detailed syntax, examples, and usage reference.

UNHEX

Learn how to use the UNHEX string function in PlaidCloud Lakehouse. For a string argument str, UNHEX(str) interprets each pair of characters in the argument...

UPPER

Learn how to use the UPPER string function in PlaidCloud Lakehouse. Returns a string with all characters changed to uppercase. Includes syntax and examples.