bugl
bugl
HomeLearnPatternsPathsSearchPremium
HomeLearnPatternsPaths

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

SQL Server LOWER() Function

Example

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

Definition and Usage

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

Note

Also look at the UPPER() function.

Syntax

LOWER(
text
)

Parameter Values

ParameterDescription
textRequired. The string to convert

Technical Details

Works in:SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

Previous

SQL Server LEN() Function

Next

SQL Server LTRIM() Function