Dear all,
Can you help me to do the char count in a query....

Example:##

table-A
---------
Nric Name
---- ----
G5558114U ramanathan
G5697744G rammohan
-----------------------

I want to find no of 'a'-s in the field Name

Name No'a's
---- -------
ramanathan 4
rammohan 2
-------------------------------------------