InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 02:36:22 GMT20http://www.sqlservercentral.com/Forums/Topic668537-338-1.aspxAs first I would suggest to change the type of your VARCHAR(MAX) column to XML.Here a little example:[code]DECLARE @v VARCHAR(MAX)SET @v = '<Root><Age>45</Age></Root>'DECLARE @xml XMLSET @xml = @vSET @xml.modify(' replace value of (/Root/Age/text())[1] with "20" ')select @xml[/code]GreetsFloWed, 04 Mar 2009 15:25:27 GMTFlorian Reischlhttp://www.sqlservercentral.com/Forums/Topic668537-338-1.aspxThe xml data looks something like thisdata id="AGE_CAT"AGE-30/data data id="BMI_CATEGORY"data id="HEIGHT"instead of 30 is the age column in table is updated to 35 the xml column should reflect this change.Wed, 04 Mar 2009 14:30:25 GMTishaan99http://www.sqlservercentral.com/Forums/Topic668537-338-1.aspxsomehow xml data doesnt show up to clarify the questions. its something likexml = Wed, 04 Mar 2009 14:06:25 GMTishaan99http://www.sqlservercentral.com/Forums/Topic668537-338-1.aspxRunning an update directly on xml column wont help as its a concatenation of age, dob, firstname, lname and many other columns. something likeif age = 35xml = ........(how is it possible to change the 63 to 35) . Wed, 04 Mar 2009 14:03:37 GMTishaan99http://www.sqlservercentral.com/Forums/Topic668537-338-1.aspxWhat exactly are you trying to accomplish? Just running an update on the xml column or creating a trigger so the xml column is updated everytime the age changes? Could you send an example of what the xml column might look like? Is it true xml? Cheers,BrianWed, 04 Mar 2009 12:07:06 GMTbeezellhttp://www.sqlservercentral.com/Forums/Topic668537-338-1.aspxI have a table which has column age and this column gets used in another column(xml) in the same table. ex table1Age varchar(3),xml varchar(max) - This is an xml column which is a concatenation of many columns in the table and age is one of them if age = 35xml = ........(how is it possible to change the 63 to 35) . This is not just one records there are quite a few with different age. so how can i get this in single update than writing multiple updates for each user. ANy help on this wil lbe greatly appreciatedTIAWed, 04 Mar 2009 11:29:54 GMTishaan99