I have sort of an odd situation. I have a lot of distributed machines working on a simulation. They each start out with their own work, process it, and eventually put it into a SQL database.<BR ...

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 ...

Fortunately, SQL offers a number of clauses and operators for sorting, grouping, and summarizing. The following tips will help you discern when to sort, when to group, and when and how to summarize.