Subject Looking for a stored procedure or function that can find the second occurance of value passed in
Author SoftTech
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