Problem With Case Syntax

Hi,
I require some help with a SP. I have written the following CASE
block but it is giving me an syntax error with Case statement.

Here @loc_id, @id_val and @inid are input parameters to the SP.

Basically what I am doing is I am selecting the column from table based on
the input parameter @loc_id I want to use Case and avoid IF statements as Case will reduce the execution time.

If any of you have faced such problem and have a sloution then do let me know.

-- SP section starts

CASE @loc_id
WHEN 1 THEN select @id_val = val1 from id_val where name = @inid
WHEN 2 THEN select @id_val = val2 from id_val where name = @inid
WHEN 3 THEN select @id_val = val3 from id_val where name = @inid
WHEN 4 THEN select @id_val = val4 from id_val where name = @inid
WHEN 5 THEN select @id_val = val5 from id_val where name = @inid
WHEN 6 THEN select @id_val = val6 from id_val where name = @inid
WHEN 7 THEN select @id_val = val7 from id_val where name = @inid
WHEN 8 THEN select @id_val = val8 from id_val where name = @inid
WHEN 9 THEN select @id_val = val9 from id_val where name = @inid
END
-- SP section ends

Thanks & Regards
____________________
Mukund Joshi
J.Mukund@zensar.com