SQL UCASE() function

Question

Hi guys Can someone tell me the use of UCASE() function in SQL?

Priya Linge · Answer

Hi 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 LastNameFirstName 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 Ahlawat · Answer

Thanks all

Hemant Kumar · Answer

The UCASE() Function The UCASE() function converts the value of a field to uppercase. SQL UCASE() Syntax SELECT UCASE(column_name) FROM table_name Syntax for SQL Server SELECT UPPER(column_name) FROM table_name

Prashant Chaudhary · Answer

Hello Akash This function is used for converting the text in upper case . Like abc will get converted into ABC.