[AccessD] Text Field Sort Order 1.1 - 10 - 2 into 1.1 - 2 - 1 0

Is there any reason you can't make it numeric?

-----Original Message-----
From: Borge Steen Hansen [mailto:pcs at azizaz.com] 
Sent: 16 June 2003 14:19
To: accessd at databaseadvisors.com
Subject: [AccessD] Text Field Sort Order 1.1 - 10 - 2 into 1.1 - 2 - 10

We have a text field with data like this when sorted ascending:

1
1.1
1.2
10
10.1
11
11.1
11.2
2
2.1
2.2
3
3.1.
3.1.1
3.1.2
3.1.3
4
etc etc.

Any one got ideas for how to sort the field like this:
1
1.1
1.2
2
2.1
2.2
3
3.1.
3.1.1
3.1.2
3.1.3
4
....

10
10.1
11
11.1
11.2

?????

Regards
Borge Hansen

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com