Iīm trying to store a xml updategram into my SQLServer 2k database. Everything works fine until I try to store a value into a field of Money type. I get the message that I should use the CONVERT function to change the type from nvarchar(in the xml updategram) to money (the db field).

How do I do this??

When I fetch from the database with FOR XML the conversion goes by itself...

Many Thanks in advance!!
/Jonas Ekestam