Paul:

Thanks for the response. You hit the nail on the head as to what I'm trying to do.

It's SQL 2005 Enterprise in most cases but could be SQL 2000...