I have the following the query running dynamically SELECT * FROM Vehicles WHERE (DKID IN (69954)) ORDER BY case when ImageName1 = ‘na’ then 0 else 1 end, Make , Model, Year DESC This is returning the following error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ‘na’.
SQL Server- ORDER BY CASE
- Post author By user user
- Post date
- Categories In sql, sql-server
- 9 Comments on SQL Server- ORDER BY CASE