*** Get TABLE *** DECLARE @xml xml SET @xml = ... SELECT T.c.value('Text[1]','varchar(35)') AS MyText , T.c.value('Selected[1]','varchar(5)') AS Selected FROM @xml.nodes('/AIRInfo/Platform/ArrayOfListItem/ListItem') T(c) -- ???? *** Get value directly *** @ProjectInfo.value('(/ProjectInfo/project_type_id)[1]', 'int') *** SELECT *** vm.AfterTaxYrOfFirstContrib As "AfterTaxYrOfFirstContrib" , m.ex_user_id As "PersonalInfo/MemberID" *** Check to see if a value exists within the XML *** @XML.exist('//Selected/../Text[. = "SQL"]')
