InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 21:00:40 GMT20http://www.sqlservercentral.com/Forums/Topic1392332-392-1.aspxChangexmltext.query('/PARAMS/FILTERS/CRM')toxmltext.query('/PARAMS/FILTERS/CRM/text()')Tue, 04 Dec 2012 04:01:27 GMTMark-101232http://www.sqlservercentral.com/Forums/Topic1392332-392-1.aspxhi guys,Still trying to get my head around XqueryI have the following logic [code="sql"]SET @CRM = ( SELECT TOP 1 CRM FROM ( SELECT cast(xmltext.query('/PARAMS/FILTERS/CRM')as nvarchar(max)) as 'CRM' FROM #XML ) X )[/code]Which returns me the following result[code="SQL"]<CRM>ONLY<TYPE>FSACLOSED</TYPE><TYPE>NRCLOSED</TYPE></CRM>[/code]I would like to get hold of just the 'ONLY' part of this string, i.e. only the value under the root of the node, not the child nodes or their values.Can I do this with XQuery or do I need to use string manipulation to isolate it?Tue, 04 Dec 2012 03:42:59 GMTaaron.reese