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