>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
George
Ubi caritas et amor, deus ibi est