Thanks, Hugo.

As an regular user of SQL but not a full-time dba, I find these questions helpful in learning the nuances of the t-SQL language. My original thought was...

It should be noted that this requires SQL2012. In SQL2008R2 & prior, this error message will be returned as CHOOSE is not yet supported.

Msg 195, Level 15, State 10,...

Thank you, Jeff and Lynn for pointing me in the right direction. Now I'm off to brush up on my XML...:cool: