SQL FunctionsString FunctionsOn this pageString FunctionsThis section provides reference information for the string-related functions in Databend.String Manipulation:CONCATCONCAT_WSINSERTLEFTLPADREPEATREPLACEREVERSERIGHTRPADSPLITSPLIT_PARTSUBSTRSUBSTRINGTRIMString Information:ASCIIBIT_LENGTHCHAR_LENGTHCHARACTER_LENGTHINSTRLENGTHLOCATEOCTET_LENGTHORDPOSITIONSTRCMPCase Conversion:LCASELOWERUCASEUPPERRegular Expressions:LIKENOT_LIKENOT_REGEXPNOT_RLIKEREGEXPREGEXP_INSTRREGEXP_LIKEREGEXP_REPLACEREGEXP_SUBSTRRLIKEEncoding and Decoding:BINFROM_BASE64HEXOCTTO_BASE64UNHEXMiscellaneous:CHARMIDQUOTESOUNDEXSOUNDSLIKESPACE