>>>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.
That's what I meant - each part should be large enough to fit the widest one.