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 ...

I want to set up a stored procedure where the data is ordered by column according to user input, i.e.GetSomeData(@SearchPhrase varchar(80), @SortCode int) ASSELECT Field1, Field2, Field3 FROM tbl ...