So I am trying to create an a to z directory from a list of items which should be an easy task and it is really, however, I am trying to find the most efficient way of doing it.
So I was thinking use querystring as a filter value and then loop through, outputting the items where the first letter matches the letter that is specified in the querystring.
This works, yay! But i know it is inefficient, I shoup be querying the list for all items that have the first letter and then displaying them.
Anyone know a good way to do this, even pseudo code is fine, i am not expecting anyone to do this for me just pointing in the right direction would be good.
For clarification, I want to create this in code, no code solutions are no good here as there is other stuff going on too.