Hi Craig
No ::(
1.1
1.10
1.2
1.2.R
10.1
goes to (lets say len=5)
001.1
01.10
001.2
1.2.R
010.1
sorts to
1.1
1.2
1.10
10.1
1.2.Rshould be
1.1
1.2
1.2.R1.10
10.1
Thank you anyway
Agnes
>Off the top of my head, without testing
>
>SELECT PADL(ALLTRIM(field), LEN(field), "0") AS SortOrd, field
> FROM table
> ORDER BY SortOrd
>
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]
