Latest

recent

SQL UCASE() Function

The UCASE() Function

The UCASE() function converts the value of a field to uppercase.

SQL UCASE() Syntax

SELECT UCASE(column_name) FROM table_name


SQL UCASE() Example

We have the following "Persons" table:

P_Id LastName FirstName Address City
1 Hansen Ola Timoteivn 10 Sandnes
2 Svendson Tove Borgvn 23 Sandnes
3 Pettersen Kari Storgt 20 Stavanger

Now we want to select the content of the "LastName" and "FirstName" columns above, and convert the "LastName" column to uppercase.

We use the following SELECT statement:

SELECT UCASE(LastName) as LastName,FirstName 
FROM Persons

The result-set will look like this:

LastName FirstName
HANSEN Ola
SVENDSON Tove
PETTERSEN Kari
SQL UCASE() Function Reviewed by 1000sourcecodes on 01:18 Rating: 5
Powered by Blogger.