how about Multiple columns

such as

declare @OrderBy varchar(200)

set @OrderBy = 'FIRST_NAME,LAST_NAME'

SELECT * FROM RESOURCE

order by case @OrderBy

WHEN 'FIRST_NAME,LAST_NAME' THEN FIRST_NAME,LAST_NAME

WHEN 'LAST_NAME,FIRST_NAME' THEN LAST_NAME,FIRST_NAME

END

It will give you a...