Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Non-Case Sensitive Sort?

Re: Non-Case Sensitive Sort?

From: Bram Stieperaere <BSE_at_NO-SPAM.sodexho-pass.be>
Date: Thu, 16 Jul 1998 14:44:43 +0200
Message-ID: <35ADF5BB.5E17884C@NO-SPAM.sodexho-pass.be> 





try



order by upper(columnname)



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,


>


> Mark Tortolano





Received on Thu Jul 16 1998 - 07:44:43 CDT












Original text of this message













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