Reference Manual
   CHAPTER 8. SQL Functions     

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

• BYTE_LENGTH function

• BYTE_SUBSTR function

• CHAR function

• CHARINDEX function

• CHAR_LENGTH function

• DIFFERENCE function

• LCASE function

• LEFT function

• LENGTH function

• LOCATE function

• PATINDEX function

• REPEAT function

• REPLICATE function

• RIGHT function

• RTRIM function

• SIMILAR function

• SOUNDEX function

• STR function

• STRING function

• STUFF function

• SUBSTR function

• TRIM function

• UCASE function

• UPPER function