Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: String function
> ST := 'THIS IS A STRING';
> N := XFunction ( ST, 'S' ); // return 3
> N := XFunction ( ST, 'IS' ); // return 2
> N := XFunction ( ST, 'X' ); // return 0
you may replace every part of the string that does not fit into your pattern with <null> and then use length() with the rest.
hth,
michael spellbrink Received on Tue Aug 26 2003 - 10:47:37 CDT