Hi guys,
Can someone tell me the use of UCASE() function in SQL?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Priya LingePosted Nov 28, 2011, 12:19 AM
1.The UCASE() function converts the value of a field to uppercase.
2.SQL UCASE() Syntax
SELECT UCASE(column_name) FROM table_name
3.Syntax for SQL Server
SELECT UPPER(column_name) FROM table_name
4.Example :
SELECT UCASE(LastName) as LastName,FirstName FROM Persons
OutPut :
LastName FirstName
SHARMA Sachin
For more information please check below links,
http://www.roseindia.net/sql/sql-ucase-function.shtml
Hope this will help you.
Thanks.
Akash AhlawatPosted Nov 28, 2011, 11:32 PM
Hemant KumarPosted Nov 28, 2011, 12:16 AM
The UCASE() Function
The UCASE() function converts the value of a field to uppercase.
SQL UCASE() Syntax
Syntax for SQL Server
Prashant ChaudharyPosted Nov 28, 2011, 12:14 AM
This function is used for converting the text in upper case . Like abc will get converted into ABC.