LOWER

The LOWER function makes all the alphabetical characters in a given string lowercase. It can be used to format output, or to make case-insensitive comparisons.

Syntax

LOWER (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 LOWER does not turn it into an empty string.

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

Data Type of string	Output Type
CHAR, LONGVARCHAR, STRING, VARCHAR	Same as the input type; for example, if the input is of type VARCHAR, the output is also of type VARCHAR.
NULL	NULL

Example (With a Comparison)

SELECT ContactLastName AS Name

FROM /shared/examples/ds_orders/customers

WHERE LOWER (ContactLastName) LIKE '%Ho%';

This example would convert all the letters in a ContactLastName to lowercase and pull out all the names from the table customers containing the sequence ho, such as:

Howard

Honner

Nicholson

Thompson

Example (Other Contexts)

SELECT LOWER (products.ProductName) Name,

LOWER ('YOU') Expr4,

LOWER ('      ') Expr6,

LOWER ('YoU 9 fEEt') Expr2,

LOWER (NULL) Expr1

FROM /shared/examples/ds_inventory/products products