>>>Hello all
>>>
>>>What is the best way to use an integer field plus a date field to create an index?
>>>
>>>TIA
>>Depends.
>>What you need might be bintoc(fi)+dtos(fd), dtos(fd)+bintoc(fi), padl(fi,10,'0')+dtos(fd) and vice versa.
>>Cetin
>
>details, details. you're killing me with details. :)
>
>thanks.
Well you're lucky I didn't ask why would you need such a compound key:)
Cetin