SQL Reference Guide

LCASE function (ODBC compatible)

Syntax

LCASE ( char_expression )

Description

The scalar function LCASE returns the result of the argument character expression after converting all the characters to lowercase. LCASE is the same as LOWER but provides ODBC-compatible syntax.

Example

SELECT *

FROM customer

WHERE LCASE (name) = 'smith' ;

Notes

• The argument to the function must be of character type.
• The result type is based on the argument type.
• If the argument expression evaluates to null, the result is null.