Re: Help: Case insensitive sort.

The Peasant (prashant_at_cs.pitt.edu) wrote:
> Hi !!,
 

> We came across a problem (feature) which we need some insights into.
> Oracle seems to differenciate (rightly so) between upper and lower case
> when we are performing sort on a char field.
> The thing we want to accomplish is for oracle to not-differenciate
> between 'A' and 'a'etc...
> so when we query the data sorted on say title we would like to see the
> following,

ORDER BY UPPER(TITLE) instead of ORDER BY TITLE

--
 _________________________   __________________________________________
/  Tommy Wareing          \ /  I've been looking for an original sin,  \
|  p0070621_at_brookes.ac.uk  X   One with a twist and a bit of a spin    |
\  0865-483389            / \     -- Pandora's Box, Jim Steinman       /
 ~~~~~~~~~~~~~~~~~~~~~~~~~   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~