declare @Text xml ;
set @Text= '<?xml
version="1.0" encoding="utf-8"?>
<Project>
<System_Record_ID><![CDATA[35]]></System_Record_ID>
<Project_ID><![CDATA[1100]]></Project_ID>
</Project>'
;with t as (select
@Text [xmlcolumn])
--select * from t
SELECT
x.a.value('(System_Record_ID)[1]','nvarchar(max)') as [System_Record_ID]
,
x.a.value('(Project_ID)[1]','nvarchar(max)') as [Project_ID]
FROM t
cross apply
t.xmlcolumn.nodes('//Project')
x(a)
