Sorry, I found out...

if object_id('tempdb.dbo.#Temp') is not null

drop table dbo.#Temp

CREATE TABLE #Temp (col xml)

INSERT #Temp (col)

select '<?xml version="1.0"?>

<soap:Envelope

xmlns:soap="http://www.w3.org/2001/12/soap-envelope"

soap:encodingStyle="http://www.w3.org/2001/12/soap-encoding">

<soap:Body xmlns:m="http://www.example.org/stock">

<m:GetStockPrice>

<m:StockName>0.018</m:StockName>

</m:GetStockPrice>

</soap:Body>

</soap:Envelope>';WITH XMLNAMESPACES ( 'http://www.w3.org/2001/12/soap-envelope' as "soap", 'http://www.example.org/stock' as "m")

select T.c.value('m:StockName[1]','decimal(8,3)')

from #Temp

cross apply col.nodes('soap:Envelope/soap:Body/m:GetStockPrice') AS T(c)