Crescencio,
Thank you.
The article gave lots of ways and was very informative to my current level.
The multiple case statements method worked best for sorting by all columns of a datagrid, and then the ascending/descending part I could not get to work because one field was a count(1) as hits involved in the group by username aggregation was not being recognized as a valid column.
So I made my main query a sub-query without an order by clause and then ordered by in the super query. This worked fine then for all cases.
Thanks again for such a quick reply.
>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