Thanks, Rich and Allen... I guess I'm too much of a VB programmer, treating SPs as functions!

Thanks, you guys are not only good -- but quick!

Thanks, Sriram. That gives me just what I was looking for. The indexes I thought were 'missing'' (I didn't see them in Enterprise Mgr) are there after all!

Thanks

Thanks for your replies. In the short term we have come up with another method, but it required creation of a temporary table, which now gives me additional housekeeping duties.

I'd...