>>I have a composite key that consists of two integer fields. How do I create the composite key?
>>
>>If I do STR(iKey1)+STR(iKey2), I will get a long string, right? I can't alltrim them because that will make the composite index wrong, right? Do I have to fix the number of characters for each field of the composite key?
>>
>>Thanks in advance.
>
>If this is neither a primary or candidate key, use:
>
>BINTOC(iKey1) + BINTOC(iKey2)
>
>These function where specifically designed to work with integer keys.
>
>hth,
>
>George

Excellent, George. You never run out of opportunities to learn about functions you either missed or hadn't yet seen. :-)

Bill