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