Xref: alice comp.databases.oracle.tools:30999
Path: alice!news-feed.fnsi.net!oleane!newsfeed.mathworks.com!wn3feed!worldnet.att.net!207.24.196.41!nntphub.cb.lucent.com!news
From: Kenneth C Stahl <BluesSax@Unforgettable.com>
Newsgroups: comp.databases.oracle.tools
Subject: Re: case insensitive order by
Date: Fri, 27 Aug 1999 13:55:30 -0400
Organization: Xyzzy Plugh Plover
Lines: 17
Message-ID: <37C6D112.C8C381A@Unforgettable.com>
References: <37C5453B.370BDCE3@evolv.com>
Reply-To: BluesSax@Unforgettable.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.51 [en] (Win95; U)
X-Accept-Language: en-US,en

pradeep paudyal wrote:

> I was curious if anybody knows how to do case insensitive order by in
> sql queries?
> Is their anything specific to oracle, too?
> Thanks

You "can" use upper() or lower() on the order by clause, but there may be
a performance penalty for that. For example:

select col1,col2
from mytable
order by upper(col1);

Ken