Create a new table and store the alphabets, and by the following query u must get ur output....

select Letter, COUNT(Name)

from #Letters

LEFT JOIN Emp ON SUBSTRING(Name,1,1) = Letter

group by Letter

Regards,

Arunkumar

MCTS -...