>I've tried both solutions but still have the same problem. Cannot put them in the middle in sequence.
>I don't know whether it is important or not: the field I'd like to be indexed looks like this: UE00000105 - there's an extra two character in front of the numeric ones. I think the expressions Cetin suggested should work this way as well.
>Now I have tried a lot - including yours - but the problem remains.
>Thanks anyway
>
>Tamas
Tamas,
You said your field had 6 sequence numbers on left and last two had year. But this string as I see it is: 2 + 6 + 2.
index on right(myField,2)+substr(myField,3,6) tag mySeq
* or you might be after this one:
index on right(myField,2)+left(myField,8) tag mySeq
Would you do this:
select top 10 rand(), myField from myCursor into cursor crsTemp order by 1
copy to mySample.txt type delimited
modi comm mySample.txt
Copy paste what you see + how they should be ordered.
Cetin