Re: Sort Order

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Tue, 27 Jul 1999 04:38:41 GMT
Message-ID: <37a83761.2893921@netnews.worldnet.att.net>

On Mon, 26 Jul 1999 14:26:46 +0100, "Julian Cowking" <jcowking_at_hrmsoftware.com> wrote:

>Is there a way to change the Oracle Sort Order?
>I want Oracle to be case INSENSITIVE. At the moment it is case sensitive.
>Any way around this?

There is no way around it, that I'm aware of. You could sort by a function:

	select * from some_table
	order by upper(last_name),upper(first_name);

Converting everything to uppercase should have the effect of making the sort appear case-insensitive.

Jonathan Received on Mon Jul 26 1999 - 23:38:41 CDT