UPPER function in Amazon QLDB

Important

End of support notice: Existing customers will be able to use Amazon QLDB until end of support on 07/31/2025. For more details, see Migrate an Amazon QLDB Ledger to Amazon Aurora PostgreSQL.

In Amazon QLDB, use the UPPER function to convert all lowercase characters to uppercase characters in a given string.

Syntax

UPPER ( string )

Arguments

string

The field name or expression of data type string that the function converts.

Return type

string

Examples

SELECT UPPER('AbCdEfG!@#$') FROM << 0 >> -- 'ABCDEFG!@#$'

Related functions

• CHAR_LENGTH

• LOWER

• SUBSTRING

• TRIM