Still trying to get my head around Xquery
I have the following logic
SET @CRM = (
SELECT TOP 1 CRM FROM
cast(xmltext.query('/PARAMS/FILTERS/CRM')as nvarchar(max)) as 'CRM'
Which returns me the following result
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?