Well, the question asked how to build a table from four integers. An integer field can be up to a ten digit number.
>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?