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 -> Sorting numbers on a VARCHAR2 field

Sorting numbers on a VARCHAR2 field

From: Greg Wong <gregory.wong_at_clear.co.nz>
Date: Mon, 06 Nov 2000 00:36:47 GMT
Message-ID: <01c04789$960e8700$db671eac@icwkcheah> 






Hi,



I want to sort a field that contains numbers but when I do a order by in
the SQL query it sorts them by their ASCII values rather than their face
value..ie the numbers appear in this order : 1,10,11,2,20,21



I could can the field's datatype to a number but some of the values in this
field are also alphanumeric.



Is there a way to get around this???
Received on Sun Nov 05 2000 - 18:36:47 CST












Original text of this message













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