String functions perform conversion, extraction, or manipulation operations on strings, or return information about strings.

When working in a multibyte character set, check carefully whether the function being used returns information concerning characters or bytes.

List of functions

The following string functions are available:

• ASCII function [String]
• BASE64_DECODE function [String]
• BASE64_ENCODE function [String]
• BYTE_LENGTH function [String]
• BYTE_SUBSTR function [String]
• CHAR function [String]
• CHARINDEX function [String]
• CHAR_LENGTH function [String]
• COMPARE function [String]
• COMPRESS function [String]
• CSCONVERT function [String]
• DECOMPRESS function [String]
• DECRYPT function [String]
• DIFFERENCE function [String]
• ENCRYPT function [String]
• HASH function [String]
• INSERTSTR function [String]
• LCASE function [String]
• LEFT function [String]
• LENGTH function [String]
• LOCATE function [String]
• LOWER function [String]
• LTRIM function [String]
• NCHAR function [String]
• PATINDEX function [String]
• READ_CLIENT_FILE function [String]
• REGEXP_SUBSTR function [String]
• REPEAT function [String]
• REPLACE function [String]
• REPLICATE function [String]
• REVERSE function [String]
• RIGHT function [String]
• RTRIM function [String]
• SIMILAR function [String]
• SORTKEY function [String]
• SOUNDEX function [String]
• SPACE function [String]
• STR function [String]
• STRING function [String]
• STRTOUUID function [String]
• STUFF function [String]
• SUBSTRING function [String]
• TO_CHAR function [String]
• TO_NCHAR function [String]
• TRIM function [String]
• UCASE function [String]
• UNICODE function [String]
• UNISTR function [String]
• UPPER function [String]
• UUIDTOSTR function [String]
• XMLCONCAT function [String]
• XMLELEMENT function [String]
• XMLFOREST function [String]
• XMLGEN function [String]