in a previous SO post: The argument 1 of the XML data type method "value" must be a string literal I failed to figure out a solution but if anyone can answer this question, I can solve that previous problem.Question: how do I retrieve the full path of a given node, in the way that I can retrieve the name of a given node?\[code\]declare @x xml; set @x='<ROOT><a>111</a></ROOT>'SELECT @x.value('local-name((/ROOT/a)[1])', 'varchar(256)')\[/code\]the above will return 'a'. how do I return '/ROOT/a'?