Gail,
Apart from forcing a hint, I would like you revisit the TOP clause. I have seen TOP behaving unexpectedly particularly when you dont have an order by. Its is a wild guess, but please let us know if you got some breakthrough
----------------------------------------------------------------------------------------------------------------------------------------------------
Roshan Joe
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]