Re: case-insensitive sort
From: DA Morgan <damorgan_at_exesolutions.com>
Date: Mon, 13 Jan 2003 09:29:11 -0800
Message-ID: <3E22F767.C654F0BA_at_exesolutions.com>
Date: Mon, 13 Jan 2003 09:29:11 -0800
Message-ID: <3E22F767.C654F0BA_at_exesolutions.com>
Andrey Voronov wrote:
> And Full Table Scan?
>
> > SELECT ...
> > FROM ...
> > WHERE UPPER(field_name) = UPPER(some_value);
> >
> > Daniel Morgan
> >
The original poster is the one that didn't want to use a function based index.
Daniel Morgan Received on Mon Jan 13 2003 - 18:29:11 CET