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 pa
On Thu, 14 Mar 2013 10:00:17 -0500, "SoftTech"
wrote:
> 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 retur
function that can find the second occurance of value passed in
On Thu, 14 Mar 2013 10:00:17 -0500, "SoftTech"
wrote:
> Greetings All,
>
> I would like to pass in a string and a substr and the position of where
> the
> x occurrence is.
>
>
On Thu, 14 Mar 2013 10:29:56 -0500, "SoftTech"
wrote:
> Thanks Mark,
>
> Guess I should have stated that I need this for Firebird 1.5
>
I'd say: starting migrating ;)
You could look at FreeAdhocUDF. It has several functions that are similar
to POSITION (for example F_SUBSTR ), see
http://freea