Loading

How to fetch upper case in SQL Query

5y806SQL

Fetch the FIRST_NAME in Upper case

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jay Krishna Reddy5y ago
Accepted answer
1. Select upper(FIRST_NAME) from "Tablename";

In some cases we want to fetch the upper cases from our database table.

Here I mention the query to how to get an uppercases.

SELECT Col_name
FROM upper
WHERE Col_name = UPPER(Col_name) Collate SQL_Latin1_General_CP1_CS_AS

Example:

SELECT Favfruit
FROM upper
WHERE Favfruit = UPPER(Favfruit) Collate SQL_Latin1_General_CP1_CS_AS

Alternate query:
SELECT UPPER(Favfruit) AS Favfruit
FROM upper;