Re: [firebird-support] Looking for a stored procedure or function that can find the second occurance of value passed in

2013-03-14 Thread Mark Rotteveel
On Thu, 14 Mar 2013 10:00:17 -0500, SoftTech mi...@softtechks.com 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

Re: {Disarmed} Re: [firebird-support] Looking for a stored procedure or function that can find the second occurance of value passed in

2013-03-14 Thread SoftTech
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

Re: {Disarmed} Re: [firebird-support] Looking for a stored procedure or function that can find the second occurance of value passed in

2013-03-14 Thread Mark Rotteveel
On Thu, 14 Mar 2013 10:29:56 -0500, SoftTech mi...@softtechks.com 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 ),