Monday, 10 October 2011

SQL- Scalar Functions- UPPER()

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

No comments:

Post a Comment