LOWER Function In SQL 2008

In this article i will explain how to convert the string in lowercase.
  • 2047

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.

Create-Table-in-sql.jpg


To select the values of the "F_Name" and "L_Name" columns , and convert the "L_Name" column to lowercase.

SQL-LOWER-function.jpg

Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.