Home » SQL & PL/SQL » SQL & PL/SQL » Using Distinct and Upper in Select statement
Using Distinct and Upper in Select statement [message #200955] Thu, 02 November 2006 01:14 Go to next message
highvoltage
Messages: 12
Registered: October 2006
Location: Singapore
Junior Member
select distinct (color) FROM inventory
ORDER BY color;

how am i to insert a UPPER function in this statement as i want to result all to be in uppercase.
Re: Using Distinct and Upper in Select statement [message #200956 is a reply to message #200955] Thu, 02 November 2006 01:17 Go to previous message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,

 select distinct(upper()) from table_name


regards,

[Updated on: Thu, 02 November 2006 01:17]

Report message to a moderator

Previous Topic: Which one is pre compiled?
Next Topic: Ordering question
Goto Forum:
  


Current Time: Sat Dec 10 09:23:20 CST 2016

Total time taken to generate the page: 0.07791 seconds