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 :)

INSTR is all that you need. See:
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/functions068.htm

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Tue Jan 23 2007 - 09:48:13 CST