Order By using parameter varchar(100)

Question

Can I do "ORDER BY" by passing parameter if there's more than 1 column in parameter? For example, the parameter is 'number asc,name' , how i can use the passed parameter to order by?

Answer 1

You can use CASE..WHEN.. here

Sample:

SELECT * FROM @table
ORDER BY (CASE @SortItem WHEN 'number asc' THEN number END) asc,
         (CASE @SortItem WHEN 'name desc' THEN name END) desc