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