Re: Non-Case Sensitive Sort?

From: Arjan van Bentem <avbentem_at_DONT-YOU-DARE-cable.a2000.nl>
Date: Wed, 15 Jul 1998 21:52:16 +0200
Message-ID: <6oj19f$7d0$1@newton.a2000.nl>

>Does anyone know if it is possible to sort ASC in a query without
>taking the case into account?

You can sort on anything, even if in your query you do not actually select that data. So, using "order by to_lower( my_column ) asc" should do the job.

Arjan. Received on Wed Jul 15 1998 - 14:52:16 CDT

This message: [ Message body ]
Next message: Arjan van Bentem: "How to get date of last table change (DML) ?"
Previous message: Arjan van Bentem: "Re: Oracle Built in Packages?"
In reply to: Mark Tortolano: "Non-Case Sensitive Sort?"
Next in thread: Bram Stieperaere: "Re: Non-Case Sensitive Sort?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US