>>Hi Craig
>>
>>No ::(
>>
>>1.1
>>1.10
>>1.2
>>1.2.R
>>10.1
>
>I don't see any other way but to split this into fields. Each field is a string, containing a character representation of a chunk which was originally between the dots...
>
>select getwordnum(fld, 1, "."), getwordnum(fld,2, ".") ... order by 1,2,3,4
>
>Now if you want 1.12 to sort after 1.2, you may need to left-pad the numbers to their maximal length.

You have to double the field length to allow for mixed cases.

regards

thomas