Re: case insensitive order by
From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Fri, 27 Aug 1999 13:55:30 -0400
Message-ID: <37C6D112.C8C381A_at_Unforgettable.com>
Date: Fri, 27 Aug 1999 13:55:30 -0400
Message-ID: <37C6D112.C8C381A_at_Unforgettable.com>
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 Received on Fri Aug 27 1999 - 19:55:30 CEST