Case Statement is Order By Clause !!

Case Statement is Order By Clause !!

 

  

Hi All,


I need to order the resultset depending on certain
criteria and one of my collegues suggested to use a
case statement in Order By Clause.I checked the help
and couldnt find out how to use the case statement in
Order By clause.My main question is CAN I USE A CASE
STATEMENT in ORDER BY Clause ?

TIA,
Parag.


__________________________________________________
Do you Yahoo!?
Yahoo! News - Today's headlines
http://news.yahoo.com
MS Sql Server LazyDBA home page