>>>
>>>Would BINTOC be more efficient or faster? That is, what do you think would be an advantage of using it vs. STR?
>>
>>It creates a smaller size index file. I guess it would be slightly faster if you have millions of records in your tables.
>
>Thank you for the suggestion and for explanation. In my case only one field is integer and another one is the numeric. And the number of records in the cursor is really in just a few hundred.
You still can use bintoc function for the integer field, e.g. Bintoc(MyInteger,1) + str(myNumeric,6) I'm not 100% certain if it's worth doing this way or two STR is just the same...
If it's not broken, fix it until it is.
My Blog