reading values from xml datatype in sql database

declare @test xml

DECLARE @ProvPayNoID int

set @test = '

'

SET @ProvPayNoID = @test.value('(/Fields/Field/@Value)[3]', 'int' )

SELECT @ProvPayNoID

declare @providerpayno int

select top 100 convert(xml,ExtraProperties).value('(/Fields/Field/@Value)[1]', 'int' ) as provpayno

from dbm.MedicalClaimsStaging

where BatchId='e5fff885-91bc-40a7-9350-5d176ca2fdfa'

declare @myDoc xml

DECLARE @ProdID int

set @myDoc = '

1 year parts and labor

3 year parts and labor extended maintenance is available

'

SET @ProdID = @myDoc.value('(/Root/ProductDescription/@ProductID)[1]', 'int' )

SELECT @ProdID

'

SET @ProvPayNoID = @test.value('(/Fields/Field/@Value)[3]', 'int' )
SELECT @ProvPayNoID

declare @providerpayno int

select top 100 convert(xml,ExtraProperties).value('(/Fields/Field/@Value)[1]', 'int' ) as provpayno
from mytable



declare @myDoc xml
DECLARE @ProdID int
set @myDoc = '


1 year parts and labor
3 year parts and labor extended maintenance is available


'
SET @ProdID = @myDoc.value('(/Root/ProductDescription/@ProductID)[1]', 'int' )
SELECT @ProdID