--- In Firebird-Architect@yahoogroups.com, "m_theologos"
<theologos@...> wrote:

>
> --- In Firebird-Architect@yahoogroups.com,
> "legrand_legrand_63" <grand.brun.63@> wrote:
> >
> > For information STRPOS (rfunc UDF Library) could be a short term
> solution.
> >
> > Regarding SQL standard,
> > what should be the POSITION behavior when finding more than one
> result:
> > - returns the 1rst occurence position ?
> > - returns 0 (thats the way STRPOS do) ?
> >
>
> - 1st occurence.
>
> > Oracle's way is:
> > INSTR ( string , substring
> > , position
> > , occurrence
> > )
> > that permits to start the search at a fix position <> 1 and permits
> to
> > catch the Nth occurence of the substring.
> >
>
> Also I think that its good to have these optional params.
> Also, is very usefull especially for parsing path strings ie.
> filepaths like \\Server-A\Share-1\MyFile.txt
> web addr like http://tech.groups.yahoo.com/group/Firebird-Architect
> tel numbers and zip codes like: 0050-0234-567890
>
> to have a (non-standard) RPOSITION which scans the string from right
> to left...
>
> Any comments?
>

I forgot to tell you:
in Oracle's INSTR "occurence" can be a negativ integer, permitting
search from right to left witin the same buit-in function ;o)