SQL LCASE Function
The LCASE function converts the fields value into the lowercase.
Understand with Example
The Tutorial illustrate an example from SQL L CASE Function. In order to understand the concept of SQL L CASE Function, we create a table name Stu_Table. The create statement helps you to create a table Stu_Table.
Create Table Stu_Table
SQL statement to create table:
Insert Data into Stu_Table
The insert into insert records, rows to the Table' Stu_Table'.
SQL statement to insert data into table:
Records in the table:
The SQL Query want to select the content of the "stu_id" and "stu_name", column above ,and convert the "stu_name" column to lowercase.