SQL LCASE() Syntax
SELECT LCASE(column_name) FROM
table_name
|
Syntax for SQL Server
SELECT LOWER(column_name) FROM
table_name
|
SQL LCASE() Example
Id
|
LastName
|
FirstName
|
Address
|
City
|
1
|
Navis
|
Anto
|
Madras
|
TVL
|
2
|
Ji
|
Bala
|
Bombay
|
TVL
|
3
|
Christopher
|
Franklin
|
America
|
KK
|
Now we want to select the content of the "LastName" and "FirstName" columns above, and convert the "LastName" column to lowercase.
We use the following SELECT statement:
SELECT LCASE(LastName) as
LastName,FirstName FROM Persons
|
The result-set will look like this:
LastName
|
FirstName
|
Navis
|
Anto
|
ji
|
Bala
|
Christopher
|
Franklin
|
0 comments:
Post a Comment