Try this:

select '<Collateral1><Collateral2><Collateral3><Value>'

+ convert(varchar(20), TableValue)

+ '</Value></Collateral3></Collateral2></Collateral1>'

from [Table]

You may parse the entire XML in 2 steps, if your procedure is called in ASP or VB.

1. Make a new stored procedure. You use here the READTEXT statement to read...

I solved the problem of comments begining on one row and ending on the next row. But I still have a beautifull  error:

"-" is...

I've already begun applying this, but for now only for comments like "-- some comment".

It's not verry easy cause a procedure may have more than 1 row in syscomments, and...