>>>Works in 2008 too, but as Naomi, I'm not sure what you mean?
>>>You just tell us that this is possible?
>>
>>Hi Boris,
>>
>>I forgot what technique would we use to dynamically control the sort order (DESC or ASC) ?
>
>
>:-)
>NO WAY!
>ASC or DESC must be AFTER the CASE and it couldn't be used in CASE.

Here is a way with double case - I knew I read it before

http://jingyang.spaces.live.com/blog/cns!CC21A118B1B5250!223.entry