Splitting XML

• rams.prsk

  Ten Centuries

  Points: 1241

  More actions

  September 29, 2011 at 1:52 am

  #390508

  When I ran my SP in server i will get the below xml :

  <ReturnMessage id="3654397910">

  <AdC ocean="AORWGL">4815043</AdC>

  <MessageStatus code="100" time="2011-09-25 22:02:55">status ok</MessageStatus>

  <MessageData>700A200000160039C943C00000</MessageData>

  <Flags les="0" app="0" />

  </ReturnMessage>

  Now, I want the split the <MessageData> element value 700A200000160039C943C00000 as 7-00-A2-00000160-039c943c-00000.

  Kindly help me in this!! Its very urgent...

  Thanks

  rams

• ColdCoffee

  SSC-Dedicated

  Points: 39972

  More actions

  September 29, 2011 at 2:01 am

  #1388212

  There is a function called STUFF which will do exactly what you asked for.