Re: String function

"Max" <massimo.panero_at_ideainformatica.org> wrote in message news:bifarn$8hvkb$1_at_ID-121437.news.uni-berlin.de...
> Is there a function that return how many occurrence of a substring are in
a
> string?
> Or how can i do by myself?
> Example:
> ST := 'THIS IS A STRING';
> N := XFunction ( ST, 'S' ); // return 3
> N := XFunction ( ST, 'IS' ); // return 2
> N := XFunction ( ST, 'X' ); // return 0
>
>

just write a function with a while loop calling the native instr function. When the search string isn't found anymore instr returns 0

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address