JJB - This DB resides at a client site so who knows when it will get upgraded. Thanks again for your input.

For others, I confirmed what JJB mentioned in an...

JJB - Thanks for your input.

The database instance I was trying this with is SQL Server 2000 and the highest compatibility level available is 80. So I have to...

The following code works, but either of the commented lines produce a syntax error in my environment. When the code from the article is cut and pasted it produces...