how to get multiple occurences of a particular substring in a string

• s-353967

  Newbie

  Points: 7

  More actions

  January 1, 2007 at 10:37 pm

  #176227

  I want to search for a particulat substring in a string.But I should be able to specify the occurence no. Basically if there are multiple occurences of the same substring in a string then I would like to get both the occurences and not just the first occurence.

• Sql Junkie-204042

  Hall of Fame

  Points: 3874

  More actions

  January 2, 2007 at 6:29 am

  #680727

  You will have to use a function. Here is a good article that I found - look for OCCURS function

  http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115