Forces a string to upper-case.

Syntax

---

UPPER(<StringExpression>)

<StringExpression> = 

Type of:

CHARACTER|CHAR
CHARACTER VARYING|VARCHAR
GUID
CHARACTER LARGE OBJECT|CLOB

Returns

---

Same as input

Usage

---

The UPPER function converts all characters in a string value to upper-case. The collation of the input value is used to determine how the upper-case operation is performed.

Examples

---

SELECT UPPER(CustomerID) AS CustomerID
FROM Customers

SQL 2003 Standard Deviations

---

This function deviates from the SQL 2003 standard in the following ways: