Subject | Re: The POSITION |
---|---|
Author | legrand_legrand_63 |
Post date | 2006-10-01T01:54:48Z |
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
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