View Single Post

   
  #4 (permalink)  
Old 04-20-2008, 10:24 AM
scottishpoet
 
Posts: n/a
Default Re: numeric sorting on a char field having a decimal

if its something you need to do frequently then a little bit of
redisgn! Store the bit before the "decimal" seperator and the bit after
the ."decimal" seperator as seperate columns

then

select before, after, before||"."||after
order by 1, 2

Reply With Quote