LOWER (Transact-SQL)

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

Transact-SQL Syntax Conventions

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 or nvarchar

Examples

The following example uses the LOWER function, the UPPER function, and nests the UPPER function inside the LOWER function in selecting product names that have prices between $11 and $20.

USE AdventureWorks;
GO
SELECT LOWER(SUBSTRING(Name, 1, 20)) AS Lower, 
   UPPER(SUBSTRING(Name, 1, 20)) AS Upper, 
   LOWER(UPPER(SUBSTRING(Name, 1, 20))) As LowerUpper
FROM Production.Product
WHERE ListPrice between 11.00 and 20.00;
GO

Here is the result set.

Lower                    Upper                    LowerUpper           
---------------------    ---------------------    -------------------- 
minipump                 MINIPUMP                 minipump
taillights - battery     TAILLIGHTS - BATTERY     taillights - battery

(2 row(s) affected)

See Also

Reference

Data Types (Transact-SQL)
String Functions (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance