Hi John,
You're right about avoiding UDF's. I was tempted for a second to create a new field in Phone that would store the reverse number and index on that.
(The reverse number is great for searching phone numbers with/without the area code. A good example of how not to design a phone table. The area code should be in it's own field!)
Thanks for your time again.


>Good find. I could see how coverage logging would mess up the works. It is one of the many reasons why I like to steer clear of UDF-based indexes...