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 |