LISTING 6: Column Name as a Parameter, Romley's Solution

ALTER PROC GetSortedShippers
  @ColName AS sysname
AS

SELECT *
FROM Shippers
ORDER BY
  CASE @ColName WHEN 'ShipperID'   THEN ShipperID   ELSE NULL END,
  CASE @ColName WHEN 'CompanyName' THEN CompanyName ELSE NULL END,
  CASE @ColName WHEN 'Phone'       THEN Phone       ELSE NULL END