UPPER

The UPPER function returns the specified string with all alphabetical characters uppercase. It can be used it to format output, or to make case-insensitive comparisons.

Syntax

UPPER (string)

Remarks

•

The input string must be enclosed within single-quotes.

•

If the input is an empty string, the output is also an empty string.

•

If the input contains only space characters enclosed in single-quotes, it is not empty, and UPPER does not turn it into an empty string.

The following table lists the input types that you can use in UPPER, and their corresponding output types.

Data Type of string	Output Type
CHAR, LONGVARCHAR, NULL, VARCHAR	Same as the input.

Example

SELECT UPPER (products.ProductName) ProductName

FROM /shared/examples/ds_inventory/products products