SQL Server LOWER() Function

Example

Convert the text to lower-case:

SELECT LOWER('SQL Tutorial is FUN!');

Definition and Usage

The LOWER() function converts a string to lower - case.

Note:

Syntax

Lower(

Parameter Values

Parameter

Description text

Technical Details

Works in:

More Examples

Example

Convert the text in "CustomerName" to lower - case:

SELECT LOWER(CustomerName) AS LowercaseCustomerName

FROM Customers;

Previous

Next