Thanks! That worked great.

Quick other question. Can I not use the DESC command when looking for the order? Like this?

ORDER BY CASE WHEN @ordervar ='order1' THEN A_Table.ID DESC

WHEN @ordervar...