SQL LCASE() | LOWER() Function

SQL LCASE() | LOWER() Syntax

For MS Access / ORACLE / MY SQL

//  Convert a input string or text expression to lowercase

SELECT LCASE(string or text);

//  Convert a specific table column value to lowercase

SELECT LCASE(column_name1) FROM table_name;

For SQL SERVER / MySql

//  Convert a input string or text expression to lowercase

SELECT LOWER(string or text);

//  Convert a specific table column value to lowercase

SELECT LOWER(column_name1) FROM table_name;

SQL LCASE() | LOWER() Example - Using Expression Or Formula

The following SQL SELECT statement will convert of a given input string to lowercase:

For MS Access / ORACLE / MY SQL

SELECT LCASE('SimmanChith.COM');

For SQL SERVER / MySql

SELECT LOWER('SimmanChith.COM');

The result of above query is:

Sample Database Table - Employee

SQL LCASE() | LOWER() Example

The following SQL statement selects the "ID" and "Dept" fields from the "Employee" table, and converts the "Dept" column to lowercase:

For MS Access / ORACLE / MY SQL

SELECT ID, 
LCASE(Dept) As 'Dept Column In Lower Case' 
FROM Employee;

For SQL SERVER / MySql

SELECT ID, 
LOWER(Dept) As 'Dept Column In Lower Case' 
FROM Employee;

The result of above query is: