Sorry forgot to say using sql server 2005, but you probably already got that.

Tried running the code but get the following error:

The argument 1 of the xml data type method...

Thanks for the Code.

We are starting a new design so at the moment nothing is fixed.

Understand your point of view as this does not fit into the relational model,...