Home Forums Programming XML Access Attribute Value RE: Access Attribute Value
Yet Another DBA
SSCarpal Tunnel
Points: 4299
More actions
September 1, 2015 at 4:41 am
#1823587
select replace( cast(
@myDoc.query('for $e
in ( /Root/ProductDescription/Features/Warranty/@Productname )
return string( $e )
' ) as varchar(100)) , space(1) , '/' )
Result is C/D/E