Re: Case insensitive searching

From: Mark Wagoner <mwagoner_at_iac.net>
Date: 1997/04/16
Message-ID: <5j2gn6$5d6$2@ocoee.iac.net>#1/1

cmunday_at_neumann.une.edu.au (Craig Munday) wrote:

>Hi,

>Being a DBA currently moving our systems from Sybase to Oracle I have a newbie
>question concerning sort ordered.

>Is it possible to configure an Oracle Database/Instance with a case
>insensitive sort order?

>Your help would be much appreciated.
>Craig.

You can specify the case to use in your order by clause, e.g., ORDER BY UPPER(colname).

--
Mark Wagoner
mwagoner_at_iac.net

Received on Wed Apr 16 1997 - 00:00:00 CDT