String-manipulation functions

String-manipulation functions accept arguments of type CHAR, NCHAR, VARCHAR, NVARCHAR, or LVARCHAR. You can use a string-manipulation function anywhere you use an expression.

The following functions convert between upper and lowercase letters in a character string:
  • LOWER
  • UPPER
  • INITCAP
The following functions manipulate character strings in various ways:
  • REPLACE
  • SUBSTR
  • SUBSTRING
  • LPAD
  • RPAD
Restriction: You cannot overload any of the string-manipulation functions to handle extended data types.