有没有什么方法去掉

[truelove7283159]

declare @ap_res_xml varchar(4000)

set @ap_res_xml="<?xml version='1.0' standalone = 'no'?>
<subresourceInfos>
<subresourceinfo id='1'>
<RN_code>1</RN_code>
<RN_name>abc</RN_name>
</subresourceinfo>
</subresourceInfos>"

SELECT xmlextract('//subresourceInfos/subresourceinfo/RN_name',@ap_res_xml)

得到结果：
<RN_code>abc</RN_code>

我想要的就是abc,有没有什么方法去掉<RN_code> </RN_code>

[东那个升]

declare @ap_res_xml XML

set @ap_res_xml='<?xml version="1.0" standalone = "no"?>
<subresourceInfos>
<subresourceinfo id="1">
<RN_code>1</RN_code>
<RN_name>abc</RN_name>
</subresourceinfo>
</subresourceInfos>'



SELECT @ap_res_xml.value('(/subresourceInfos/subresourceinfo/RN_name)[1]','varchar(20)' )


--------------------
abc

(1 行受影响)

[东那个升]

declare @ap_res_xml XML

set @ap_res_xml='<?xml version="1.0" standalone = "no"?>
<subresourceInfos>
<subresourceinfo id="1">
<RN_code>1</RN_code>
<RN_name>abc</RN_name>
</subresourceinfo>
</subresourceInfos>'



SELECT T.C.value('.','varchar(30)') as RN_name

FROM @ap_res_xml.nodes('/subresourceInfos/subresourceinfo/RN_name') T(C)

RN_name
------------------------------
abc

(1 行受影响)

[htl258_Tony]

[Quote=引用 1 楼 ldslove 的回复:]
SQL code
declare @ap_res_xml XML

set @ap_res_xml='<?xml version="1.0" standalone = "no"?>
<subresourceInfos>
<subresourceinfo id="1">
<RN_code>1</RN_code>
<RN_name>abc</RN_name>
</subresource……
[/Quote]UP this