Re: Help: Case insensitive sort.

jsilver (OracleCorpCanadaInc) wrote:

[3 times]

> In article <2ucuqv$kgm_at_toads.pgh.pa.us> prashant_at_cs.pitt.edu (The
> Peasant) writes:
 

> Use the LOWER function:
 

> select Title
> from ...
> order by LOWER ( title );
 

> Now, how about a hard question?

Ok. Why doesn't DISTINCT work on news articles posted from Oracle sites :)

> --
> Jerry Silver
> Oracle Vancouver
> Office: (604) 682-8965 Fax: (604) 682-5235
> Internet: jsilver_at_ca.oracle.com

--
  _________________________   _________________________
 /  Tommy Wareing          \ /                         \
|  p0070621_at_brookes.ac.uk   X   Oh No! More Amberites!  |
 \  0865-483389            / \       A. Lemming        /
  ~~~~~~~~~~~~~~~~~~~~~~~~~   ~~~~~~~~~~~~~~~~~~~~~~~~~