ASA SQL Reference
  SQL Functions
    Function types

String functions

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

When working in a multi-byte 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]

• BYTE_LENGTH function [String]

• BYTE_SUBSTR function [String]

• CHAR function [String]

• CHARINDEX function [String]

• CHAR_LENGTH function [String]

• COMPARE function [String]

• CSCONVERT function [STRING]

• DIFFERENCE function [String]

• INSERTSTR function [String]

• LCASE function [String]

• LEFT function [String]

• LENGTH function [String]

• LOCATE function [String]

• LOWER function [String]

• LTRIM function [String]

• OPENXML function [String]

• PATINDEX function [String]

• REPEAT function [String]

• REPLACE function [String]

• REPLICATE 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]

• TRIM function [String]

• UCASE function [String]

• UPPER function [String]

• UUIDTOSTR function [STRING]

• XMLAGG function [String]

• XMLCONCAT function [String]

• XMLELEMENT function [String]

• XMLFOREST function [String]

• XMLGEN function [String]