I have a product catalog I am designing for a client. The have eschewed any type of custom sorting for their users, but instead want to have everything sorted alphabetically. That's not a problem. However, now they tell me they want everything starting with a specific letter to come up first, and then everything else in the database alphabetically. For example, if the product name starts with the letter "P", it should show up before anything else, so "P A B C D E" and so forth.
I can think of how to do this the long way around, using two queries. WHERE ProductName LIKE 'P%' and then WHERE ProductName NOT LIKE 'P%'. I could grab the results, combine the arrays and send them to my template.
I would rather not do this, however. Is there any way I could accomplish this using only one query?
