I am using SQL Server 2017 Express Edition. I have a table (T1) that has a column named case. There are duplicate values in the column case. Hence I ran a query,
Select * from T1 order by id; --- This runs fine.
Select * from T1 order by Case; -- Gives error-- Msg 102, Level 15, State 1, Line 23 Incorrect syntax near ';'