Monday, 10 October 2011

SQL- Scalar Functions- LOWER()

nThe LOWER function converts the value of a field to lowercase.
Syntax:
SELECT LOWER(column_name) FROM table_name
Query:
SELECT LOWER(EMPname) AS Employee Name FROM EMPtbl1

No comments:

Post a Comment