[sql2005] order by defined value

[jlbantang]

hi guys, how would you sort columns according to defined values. suppose

action
-----------
MSC
GP
DL
IDA


output
GP
DL
MSC
IDA

i was thinking something like this:

select action from table1
order by 'gp','dl','msc','ida'

but im getting error