Hi I have a problem, don't think there's an easy solution but here goes:

I have a db text field that contains text and numbers.

I need to sort my recordset on this field, the problem is that some of the text in the fields begins with numbers.

So when i do a sort on that field 10 comes before 2.

Any ideas much appreciated!