>>
>>In a numeric case, I might look at the BINTOC() and CTOBIN() functions for creating the indexes. Should be more compact and faster.
>
>I love this place. I would never have thought of BINTOC or CTOBIN's in indexing. Actually I can't recall ever using them. All my older systems were character based, now they are interger.
>
>Thanks.
No problem. I would only use them in a compound index expression of two or more numeric values. But I got the idea from George Tasker. He's the brains on this. :-)
Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.