Re: Help: Case insensitive sort.

In article kgm_at_toads.pgh.pa.us, prashant_at_cs.pitt.edu (The Peasant) writes:
>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.

Try:

	SELECT title
	   FROM videos
	ORDER BY upper(title)
	/

It should do what you want.
Good luck!

Sincerely,

Martin Farber
Independent Oracle Consultant

                        |  NYNEX Science & Technology
                        |  500 Westchester Ave, Rm 1D10
                        |  White Plains, NY  10604
                        |     -----------------
                        |  email: farber_at_nynexst.com
                        |  Voice: 914/644-2656
                        |    FAX: 914/644-2216