retrieving value from an xml field in the db

• Terry-380449

  Default port

  Points: 1458

  More actions

  April 12, 2007 at 10:40 am

  #177343

  i have a memo field that stores data under a xml format:

  <?xml version='1.0'?> <table><field1>test</field1></table> <table><field2>test</field2></table>

  how can i retrieve in a function the value of the field, but passing it the table and/or the field name

  i have tried combination of substring and stuff, but seems too complicated

  any idea?

  tx!

• Mark Shvarts 1

  SSCertifiable

  Points: 5702

  More actions

  April 12, 2007 at 11:18 am

  #700173

  Have you tried OpenXML function ?

• Aaron Ingold

  SSCrazy Eights

  Points: 9070

  More actions

  April 12, 2007 at 11:42 am

  #700179

  Look into using the query() method from XQuery. In BOL it's "Query() method".