order by case sensitive (solved)
Posted by:
le cou
Date: September 05, 2008 11:02PM
Hello.
the query:
select name
from tb_users
order by name
is case sensitive.
Eg.:
Andrew
Jacob
Michael
andrew
jacob
michael
What I have to do to the result be like this:
andrew
Andrew
jacob
Jacob
michael
Michael
thks in advance!
Edited 1 time(s). Last edit at 09/07/2008 11:22AM by le cou.
Subject
Written By
Posted
order by case sensitive (solved)
September 05, 2008 11:02PM
September 06, 2008 05:45AM
September 06, 2008 06:42PM
September 06, 2008 06:51PM
September 06, 2008 09:46PM
September 06, 2008 11:03PM
September 07, 2008 04:47AM
September 07, 2008 11:21AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.