XML data type in SQL Server 2005

[Venkata Rajesh]

Hi,

I have an xml column in a table. One of the stored procedures need to update the value in the xml column by appending few more nodes at the end of the existing value.

E.g.

 
declare @oldXML xml, @newXML  xml
 
SET @oldXML = 
'<Root>           
<ProductDescription ProductID="1" ProductName="Road Bike">           
</ProductDescription>           
</Root>' 
 
SET @newXML = 
'<ProductDescription ProductID="2" ProductName="Car">           
</ProductDescription>'
 
set @oldXML.modify
('insert {sql:variable("@newXML")} as last into (/Root) [1]') 

is giving the below error:
XQuery [modify()]: An expression was expected

Note: @newXML can be of xml type or of varchar.

Please help me out!

Thanks in advance.
[ June 25, 2007: Message edited by: Venkata Rajesh ]