Thanks J!

I'm on my way to check out the article you recommended. I appreciate the reply.

..bob

Hi Bob

This is a recursive CTE, which is a supported structure in TSQL

One nice use for it is to navigate a parent-child relationship of uncertain depth. MSDN has an article on it at http://msdn.microsoft.com/en-us/library/ms186243.aspx