Check out http://www.sqlmag.com/Articles/Index.cfm?ArticleID=16495 HTH

>Can someone tell me how one used parameters in the order by clause to get some dynamic ordering without dynamic query building?
>
>when I use:
>group by username
>order by @sortFld
>I get:
>variables are only allowed when ordering by an expression referencing a column name.
>
>Should I use case structures in order by clause?
>I've had problems with that in context of group by
>
>or a if structure?
>
>TIA