Extracting a String From Between Two Delimiting Characters

• Lashams

  Ten Centuries

  Points: 1026

  More actions

  June 9, 2004 at 1:52 pm

  #161055

  Comments posted to this topic are about the content posted at http://www.sqlservercent

• Frances L

  SSCarpal Tunnel

  Points: 4727

  More actions

  February 16, 2006 at 12:43 pm

  #621454

  I got error from 'SUSTRING' is not a recognized function name.

• Frances L

  SSCarpal Tunnel

  Points: 4727

  More actions

  February 16, 2006 at 12:43 pm

  #621453

  I got error from 'SUSTRING' is not a recognized function name.

• Stock

  SSC Enthusiast

  Points: 171

  More actions

  April 4, 2006 at 2:54 am

  #630591

  Try "Substring"

• Varsha Chandra

  SSC Rookie

  Points: 37

  More actions

  February 4, 2010 at 10:52 pm

  #1114192

  Hi, I have a similar issue where i need to extract the data from the xml string which is present in a particular column. I need to get the result set in a way that it should pull everything between <credittaker> </credittaker> from the whole xml string. the length between this is not fixed.

  For e.g. I have a table 'EventHistory' and column 'XMLDataValue' and column data is like given below:

  <event><credittaker>HAROLD D JORDAN</credittaker><primarymonitoringparty>Russell Pleasants</primarymonitoringparty><monitoringentity></monitoringentity><primarygci>510211006</primarygci><status>Pending Initial Setup</status><active>A</active><schedulecomplete>N</schedulecomplete><author>LEAP</author><eventdatetime>Jul 4 2002 8:48AM </eventdatetime><EventCode>Credit Taker Setup Incomplete</EventCode></event>

  <event><credittaker>JORDAN HOLMAN LUMBER CO INC</credittaker><primarymonitoringparty>Susan Jones</primarymonitoringparty><monitoringentity></monitoringentity><primarygci>510156755</primarygci><status>Pending Initial Setup</status><active>A</active><schedulecomplete>N</schedulecomplete><author>LEAP</author><eventdatetime>Jul 4 2002 8:48AM </eventdatetime><EventCode>Credit Taker Setup Incomplete</EventCode></event>

  The result set should give me

  HAROLD D JORDAN

  JORDAN HOLMAN LUMBER CO INC

  from the above xml string.