View Single Post
  #2 (permalink)  
Old September 22nd, 2004, 12:55 PM
happygv happygv is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

I just played around it, not sure what the reason is, it doesn't work when DISTINCT is used along with CASE in the order by clause. It works perfect without CASE in ORDER BY Clause or, without DISTINCT in SELECT list.

Hope you should avoid one of them.

_________________________
- Vijay G
Strive for Perfection
Reply With Quote