Re: character count in a string

Eitan M wrote:
> Hello,
> how can I get a specific character count in a string
> (
> i.e : string is 56222, and I am looking for '2' occurance
> when i do :
> select charcount('56222') should return : 3
> )
>
> Thanks :)

I would look into building a user-defined function using the INSTR and SUBSTR built-in functions.

HTH -g Received on Tue Jan 23 2007 - 08:48:32 CST