Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  ORDER BY CASE

Author  Topic  kgruber Starting Member 6 Posts Posted - 2001-07-25 : 22:37:46 This ORDER BY clause gives me an error message: Incorrect syntax near the keyword 'DESC'. ORDER BY CASE WHEN @sort='1' THEN CONVERT(char(30),date_posted,121) DESC WHEN @sort='2' THEN region WHEN @sort='3' THEN project_name END Am I putting it in the wrong place?