String Functions

BodoSQL currently supports the following string functions:

• BASE64_DECODE_BINARY
• BASE64_DECODE_STRING
• BASE64_ENCODE
• CHAR
• CHARINDEX
• CONCAT
• CONCAT_WS
• EDITDISTANCE
• ENDSWITH
• HEX_DECODE_BINARY
• HEX_DECODE_STRING
• HEX_ENCODE
• INDEX
• INSERT
• JAROWINKLER_SIMILARITY
• LCASE
• LEFT
• LENGTH
• LOWER
• LPAD
• LTRIM
• MD5
• MD5_HEX
• MID
• ORD
• POSITION
• REPEAT
• REPLACE
• REVERSE
• RIGHT
• RPAD
• RTRIM
• SHA2
• SHA2_HEX
• SPACE
• SPLIT_PART
• STARTSWITH
• STRCMP
• STRTOK
• SUBSTR
• SUBSTRING
• SUBSTRING_INDEX
• TRIM
• TRY_BASE64_DECODE_BINARY
• TRY_BASE64_DECODE_STRING
• TRY_HEX_DECODE_BINARY
• TRY_HEX_DECODE_STRING
• UCASE
• UPPER