field alias for case function

Hi,

How do I give a field alias for the following sql statement:

select case id when 1 then 9 else id end case from temp_t1;

I would to give a field name for the output.

Thanks
sy Received on Thu May 01 2003 - 13:17:16 CDT