# find out how many times particular character occur in given string.

From: Sanjeev <sanjeev.atvankar_at_gmail.com>

Date: Wed, 10 Dec 2008 05:19:20 -0800 (PST)

Message-ID: <6e2ea0b9-5782-4945-962c-5c7de86dde9b@k36g2000pri.googlegroups.com>

Date: Wed, 10 Dec 2008 05:19:20 -0800 (PST)

Message-ID: <6e2ea0b9-5782-4945-962c-5c7de86dde9b@k36g2000pri.googlegroups.com>

Dear Gurus,

I want to find out how many times particular character occur in
given string.

e.g. 'A*B*C*D*E*F' count of '*' is 5

* 'A*B*C*D' count of '*' is 3*

* 'A' count of '*' is 0*

Is there any function available in SQL to find out the above requirement ?

Could anyone help me in above?

Thanking in advance

Sanjeev
Received on Wed Dec 10 2008 - 07:19:20 CST