Select data in xml

• rpatil22

  Ten Centuries

  Points: 1371

  More actions

  July 21, 2009 at 8:15 am

  #133110

  I have data in a table having one column having xml datatype.

  I want select values between ---- .

  How to do that?

• Wesley Norton

  SSCrazy

  Points: 2827

  More actions

  July 21, 2009 at 8:49 am

  #1027677

  Have you looked at PatIndex?

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  July 21, 2009 at 10:30 am

  #1027778

  I think this might help you:

  http://msdn.microsoft.com/en-us/library/ms189075(SQL.90).aspx

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question