Subject Re: The POSITION
Author legrand_legrand_63
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) ?

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.

Regards
PAscal