Posted by Ranjith on 01/26/06 16:43

'message' Field Data:
<xml>
....
<test>ABC</test>
....
</xml>

How do I query out 'ABC' from this xml field data in a SQL Server?

Assume message field is in table 'Persons'

• Next in forum: Re: ORDER BY in VIEW not working
• Prev in forum: Re: ORDER BY in VIEW not working
• Thread view: Query out an xml element from a field containing xml data

[Reply to this message]