|
-
Sep 12th, 2013, 06:01 AM
#1
Thread Starter
Addicted Member
[RESOLVED] Natural sort order in SQL Access query.
How can i sort a column (APART=CHAR field) in an access table in natural sort order with this value:
1
10
12
PART
14
2
3+4
5
6
8
9-10
I want sort in this order:
1
2
3+4
5
6
8
9-10
12
14
PART
I use "SELECT * FROM db ORDER BY APART+0" ... But not work...
Please help.
Thank you
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|