[Resolved] CASE and SPROCS

[yrwyddfa]

I am trying to do this and that damn thing won't let me

select @Something
   case SomethingElse
      when 2 then proc_AProc2
      when 3 then proc_AProc3
   end

Is there something endemically wrong in this? I can't use a UDF because the proc has a transaction in it. I can't lift the transaction outside, because other places use the sproc on its own.

Is it just a syntactic balls-up on my part?

[edit] I am using SQL Server 2000 [/edit]