Recently a question popped up over on the CakePHP google group where someone had a problem sorting on a column of “registration numbers”. This was his table sorted order by “Reg No ASC“:

-

ID Name Reg No 1 Product A 1 2 Product B 123 3 Product C 2

-
1, [...]