>>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.