LOWER (T-SQL)

Returns a character expression after converting uppercase character data to lowercase.

Syntax

LOWER(character_expression)

Arguments

character_expression

Is an expression of character or binary data. character_expression can be a constant, variable, or column. character_expression must be of a data type that is implicitly convertible to varchar. Otherwise, use CAST to explicitly convert character_expression.

Return Types

varchar

Examples

This example uses the LOWER function, the UPPER function, and nests the UPPER function inside the LOWER function in selecting book titles that have prices between $11 and $20.

USE pubs

GO

SELECT LOWER(SUBSTRING(title, 1, 20)) AS Lower,

    UPPER(SUBSTRING(title, 1, 20)) AS Upper,

    LOWER(UPPER(SUBSTRING(title, 1, 20))) As LowerUpper

FROM titles

WHERE price between 11.00 and 20.00

GO

Here is the result set:

Lower                Upper                LowerUpper          

-------------------- -------------------- --------------------

the busy executive's THE BUSY EXECUTIVE'S the busy executive's

cooking with compute COOKING WITH COMPUTE cooking with compute

straight talk about  STRAIGHT TALK ABOUT  straight talk about 

silicon valley gastr SILICON VALLEY GASTR silicon valley gastr

secrets of silicon v SECRETS OF SILICON V secrets of silicon v

prolonged data depri PROLONGED DATA DEPRI prolonged data depri

fifty years in bucki FIFTY YEARS IN BUCKI fifty years in bucki

sushi, anyone?       SUSHI, ANYONE?       sushi, anyone?      

(8 row(s) affected)

See Also