I have records that represent processes, which contain a sequence number. Now with out re-sequencing the whole process they need to insert additional steps. For example new data records would look like this” 1,2,2a,3,4,4a,4b…… etc. I changed the field type from numeric to text to allow numeric and alpha charters. This screws up my SELECT ORDER statement. Now it won’t even sort the numbers right. Is there a way to do this? Here is what I have now.

SELECT * FROM JobProc ORDER BY Sequence ASC

How can a sort the data in order?