LOWER Function In SQL 2008
In this article i will explain how to convert the string in lowercase.
Introduction
LOWER() function is a string function. LOWER() Function converts the string to lower case.
Syntax
SELECT LOWER (column_name) FROM table_name
|
Example
Suppose we have table named Employee as.
To select the values of the "F_Name" and "L_Name" columns , and convert the "L_Name" column to lowercase.