When I run the following in SQL Server it runs fine:
select * from TableA order by First_Candidate collate SQL_Latin1_General_CP1_CI_AS
But when I do the order by the ordering of the column, then I get the error:
"Expression type int is invalid for COLLATE clause. "
select * from TableA order by 7 collate SQL_Latin1_General_CP1_CI_AS
How can you overcome this?