Re: Looking for a SQL Function

"Rene Nyffenegger" <rene.nyffenegger_at_gmx.ch> wrote:
>> SELECT (LENGTH('abcdefabc') - LENGTH(REPLACE('abcdefabc','abc'))) /
>> LENGTH('abc')
>> FROM dual;
>
> Very clever! Someone is using his brain.

You took the words out of my mouth. Clever and elegant indeed. Just what I was looking for, using pure SQL, not PL/SQL.

Thanks Ralf,
Rudy Received on Wed Nov 02 2005 - 23:09:10 CST