Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Stephen Lasham Extracting a String Within Delimeters - Part 2 RE: Extracting a String Within Delimeters - Part 2

  • September 13, 2004 at 6:16 am

    #522711

    There is a typo in the SELECT code, needs to be

     

    SELECT Particulars,

         LTRIM(RTRIM(SUBSTRING(

           /* <text>> */ Particulars,

           /* <start > */   CHARINDEX(';',Particulars,1) + 1,

           /* <length> */   CHARINDEX(';',

              SUBSTRING(Particulars, CHARINDEX(';', Particulars, 1) + 1, 99) + ';') - 1

          ) ) ) AS Result_string

    FROM Sample_table