Amazon Redshift
Database Developer Guide (API Version 2012-12-01)
« PreviousNext »
View the PDF for this guide.Go to the AWS Discussion Forum for this product.Did this page help you?  Yes | No |  Tell us about it...

String functions

String functions process and manipulate character strings or expressions that evaluate to character strings. When the string argument in these functions is a literal value, it must be enclosed in single quotes. Supported data types include CHAR and VARCHAR.

The following section provides the function names, syntax, and descriptions for supported functions. All offsets into strings are 1-based.

The following leader-node only string functions are deprecated.

  • ASCII

  • GET_BIT

  • GET_BYTE

  • OCTET_LENGTH

  • SET_BIT

  • SET_BYTE

  • TO_ASCII