Stored Procedure - Declare variable to reference a column

[SkyMasterBRA]

How can I do to declare a variable to reference a column in a stored procedure to use as a ORDER BY parameter?

Cya!

 

[swampBoogie]

order by
case @c
when 'C1' then c1
when 'C2' then c2
when 'C3' then c3 end

if c1,c2 and c3 are of non-comparable types, you need to add apropriate casts.

You can also use dynamic sql

declare @s varchar(200)

@s = 'select ...' + ' order by ' +
case @c
when 'C1' then 'C1'
when 'C2' then 'C2'
when 'C3' then 'C3' end

exec(@s)

 

[SkyMasterBRA]

Thanks dude!