Subject | Looking for a stored procedure or function that can find the second occurance of value passed in |
---|---|
Author | SoftTech |
Post date | 2013-03-14T15:00:17Z |
Greetings All,
I would like to pass in a string and a substr and the position of where the
x occurrence is.
Example:
String: Then the big red fox jumped over the flowing stream."
SubStr: the
occurrence: 2
Would return 34 which is the starting position of the second "the" found in
the string passed in.
Anything like this available anywhere?
Thanks,
Mike
I would like to pass in a string and a substr and the position of where the
x occurrence is.
Example:
String: Then the big red fox jumped over the flowing stream."
SubStr: the
occurrence: 2
Would return 34 which is the starting position of the second "the" found in
the string passed in.
Anything like this available anywhere?
Thanks,
Mike