Also, your WHERE clause of PO.PODescription LIKE '%00000%' will normally produce a table scan. It's a bit hard to say for sure though as you have not posted an execution plan or your index structure as requested by the other posters.
John Rowan
====================================================== ====================================================== Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden