String Functions

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

String Manipulation:

• CONCAT
• CONCAT_WS
• INSERT
• LEFT
• LPAD
• REPEAT
• REPLACE
• REVERSE
• RIGHT
• RPAD
• SPLIT
• SPLIT_PART
• SUBSTR
• SUBSTRING
• TRANSLATE
• TRIM

String Information:

• ASCII
• BIT_LENGTH
• CHAR_LENGTH
• CHARACTER_LENGTH
• INSTR
• LENGTH
• LOCATE
• OCTET_LENGTH
• ORD
• POSITION
• STRCMP

Case Conversion:

• LCASE
• LOWER
• UCASE
• UPPER

Regular Expressions:

• LIKE
• NOT_LIKE
• NOT_REGEXP
• NOT_RLIKE
• REGEXP
• REGEXP_INSTR
• REGEXP_LIKE
• REGEXP_REPLACE
• REGEXP_SUBSTR
• RLIKE

Encoding and Decoding:

• BIN
• FROM_BASE64
• HEX
• OCT
• TO_BASE64
• UNHEX

Miscellaneous:

• CHAR
• MID
• QUOTE
• SOUNDEX
• SOUNDSLIKE
• SPACE