How to select uppercase of a name in particular column of a table

Question

Example:

Table name : example with column Emp_name

emp_name    

Ron         
Raj         
Robert

I want to display the name raj in upper case for the table example.

Are you using MySQL or MS SQL Server? (Remove the tag for the product not used.) — jarlh, Aug 17 '16 at 05:37

score 1 · Answer 1 · edited Aug 16 '16 at 23:32

1

If I understand your question, I think you should write your query as follows:

SELECT UCASE(emp_name) FROM your_table WHERE emp_name = Raj;

If you want to select all the emp_name column and display it in uppercase, you should use this instead:

SELECT UCASE(emp_name) FROM your_table;

edited Aug 16 '16 at 23:32

ishmaelMakitla

answered Aug 16 '16 at 22:15

zolastro

1

Either that or `SELECT CASE WHEN emp_name='Raj' THEN UCASE(emp_name) ELSE emp_name as new_emp_name FROM your_table`, if he wanted to return all names but only capitalise Raj – tomb Aug 16 '16 at 23:53
Is `UCASE()` MySQL or SQL Server? – jarlh Aug 17 '16 at 05:36
The UPPER function is used for SQL Server. Other SQL platforms may use the UCASE function. – zolastro Aug 17 '16 at 12:48

score 0 · Answer 2 · answered Aug 17 '16 at 14:14

0

Question is not clear whether you are asking for My sql

use UPPER() for MS SQL Server

answered Aug 17 '16 at 14:14

user3767858

2 Answers2