Re: counting number of times in strings

Yep,

I use that one as well, so effective ;)

M

>
>A cute trick...
>
>take the difference between
>
>length(string) and
>length(replace(string,search_string,null))
>
>HTH
>--
>===========================================
>Connor McDonald
>http://www.oracledba.co.uk
>
>We are born naked, wet and hungry...then things get worse
>
>

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Wed Jul 12 2000 - 00:00:00 CDT