Help: Case insensitive sort.

From: The Peasant <prashant_at_cs.pitt.edu>
Date: 23 Jun 1994 21:29:03 GMT
Message-ID: <2ucuqv$kgm_at_toads.pgh.pa.us>

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,

TITLE

---

Adams Family
avon
alexander the great
Brendas sister
....

*NOT* TITLE

---

Adams Family
Brendas sister
....

avon
alexander the great
... Etc.

I would really appriciate if some knowledgeble throws some light as to how to accomplish this.

Regards,
Prashanth. Received on Thu Jun 23 1994 - 23:29:03 CEST