Re: Case Unsensitive VARCHAR2 ordering

From: Michael S. Abbey <masint_at_istar.ca>
Date: 1998/03/22
Message-ID: <35149cf0.28466883@news.istar.ca>#1/1

On 21 Mar 1998 19:53:35 GMT, "Luca Minudel" <luca.minudel_at_nline.it> wrote:

>How can I make Oracle ignore differences between upper case and lower =
>case characters (VARCHAR02) while ordering ?
>
>Example=20
>
>
>SELECT name FROM peoples ORDER BY name;

Try ORDER BY LOWER(NAME) or ORDER BY UPPER(NAME)

Michael

+------------------------------------
+  Michael S. Abbey    Ottawa Canada
+  Co-author of Oracle8: A Beginner's Guide

+ and 5 other works in the Oracle Press Series

+------------------------------------

Received on Sun Mar 22 1998 - 00:00:00 CST