Results 1 to 6 of 6
Thread: Distribution of names
Jan 24, 2010, 09:28 #1
- Join Date
- Oct 2004
- 0 Post(s)
- 0 Thread(s)
Distribution of names
I have membership table ('members') and, regarding the surnames (in field 'surname'), I would like to generate the following:
number of members whose surname starts with 'A': xxx
number of members whose surname starts with 'B': yyy
etc, for all the letters of the alphabet.
Is there a way of achieving this in ONE query, or do I really have to loop through all 26 letters, with one query per letter?...
Many thanks for your feedback.