Is anyone out there a SQL expert? I'm trying to count all the people in my personnel table and group them by first letter of last name. I want my result set to look like this:
A 203
B 309
C 594

etc.

I can do this with multiple count statements, but am wondering if it is possible with a single SQL select statement.

Thanks in advance,
Rebecca Burlingame