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

Alphabetic data sorts alphabetically, not numerically.  If you want it
to sort as if it is numeric, then insert a zero (0) in front of all the
values less than ten (10).

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Borge Steen Hansen [mailto:pcs at azizaz.com] 
Sent: Monday 2003 Jun 16 08: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