Forces a string to lower-case.

Syntax

---

LOWER(<StringExpression>)

<StringExpression> = 

Type of:

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

Returns

---

Same as input

Usage

---

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

Examples

---

SELECT LOWER(CustomerID) AS CustomerID
FROM Customers

SQL 2003 Standard Deviations

---

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