Is there anyway to I can get it to sort using numeric for those fields. We can look at this and see that .11 should sort after .2, but I'm not sure how to tell SQL to sort a text field like that ...

This way I can take impossible-to-sort varchars, and sort them by the converted field instead, making the recordset prettier.<BR><BR>Right now SCNumber might look like the above, '99' implying ...