Thanks Mark,

Guess I should have stated that I need this for Firebird 1.5

Mike

----- Original Message -----
From: Mark Rotteveel
To: firebird-support@yahoogroups.com
Sent: Thursday, March 14, 2013 10:05 AM
Subject: {Disarmed} Re: [firebird-support] Looking for a stored procedure or function that can find the second occurance of value passed in



On Thu, 14 Mar 2013 10:00:17 -0500, "SoftTech" <miket@...>
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 return 34 which is the starting position of the second "the" found
> in
> the string passed in.
>
> Anything like this available anywhere?

You can use POSITION(...)
http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-intfunc-position.html
but you will need to keep track of the number of occurrences yourself.

Mark



--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

[Non-text portions of this message have been removed]