I agree, but I wouldn´t use STR(whatever,10) always with "10", but I´d use the appropriate width: for example, STR(Int1,5)+STR(Int2,8)+STR(Real1,10,2)...


>You can use STR() to convert each integer to a string, then concatante them together: INDEX ON STR(Int1,10)+STR(Int2,10)+...
>
>Of course, you'll have to do the conversions again each time you need to do a SEEK. You may want to try LOCATE and see if you really need the extra performance that SEEK offers.
>
>>Hi All,
>>
>>Ok, I've got a link table that links two, two part primary keys, together. And sense Seek is faster than locate, I need to index on the four part key. How do you build an index on four integers?