SQL Reference Guide

UPPER function (SQL-92 compatible)

Syntax

UPPER ( char_expression )

Description

The scalar function UPPER returns the result of the argument character expression after converting all the characters to uppercase.

Example

SELECT *

FROM customer

WHERE UPPER (name) = 'SMITH' ;

Notes

• The argument to the function must be of character type.
• The result is of character type.
• If the argument expression evaluates to null, the result is null.