Re: Non-Case Sensitive Sort?

From: Jurij Modic <jmodic_at_src.si>
Date: Wed, 15 Jul 1998 15:20:34 GMT
Message-ID: <35acc860.111302334@news.siol.net>

On Wed, 15 Jul 1998 10:26:27 GMT, mark_tortolano_at_dial.pipex.com (Mark Tortolano) wrote:

>Hi,
>
>Does anyone know if it is possible to sort ASC in a query without
>taking the case into account? My users are complaining that they want
>the query presented in asceding alphabetical order without the case of
>the field having an impact on the ordering.
>
>Thanks,

SELECT ename FROM scott.emp ORDER BY UPPER(ename) ASC;

>Mark Tortolano

Regards,
--
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Jul 15 1998 - 10:20:34 CDT