Splitting the String

• sqlfriends@sql.com

  SSCommitted

  Points: 1504

  More actions

  February 24, 2012 at 6:53 am

  #391642

  HI;

  I want to split the column name and values passing string format in stored procedure

  How can i split the string.

  ex

  'V_Name=''Compas'',V_Name_Type=''8'''

  Column name = V_Name,V_Name_Type

  columnvalues=Compas,8

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  February 24, 2012 at 6:57 am

  #1451372

  take a look at the link in my signature for the string splitter