>>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only