So I wanna sort something like "The Who" or "The Grateful Dead" by 'W' and 'G', respecively. How does one accomplish this? I tried using a function in the ORDER BY clause, but SQL syntax doesnt seem ...

I want to set up a stored procedure where the data is ordered by column according to user input, i.e.<pre class="ip-ubbcode-code-pre">GetSomeData(@SearchPhrase ...

Arranging SQL data so that you can effectively analyze it requires an understanding of how to use certain SQL clauses and operators. These tips will help you figure ...