Sql Question

Hi Syb Guys,

I have a table x with following structure

id char(2)
name char(20)

value in column 'id' will be either '1' or '2' or '3' or null. What I want to do is update column 'id' with 'X' if its '1' , 'Y' if its '2' and 'Z' if its '3' and no update for null value

Is it possible with using only one update statement? How? In Syb 11.5 I think u can use case statement, but I am using version 11.0.3.2.

Thanks
Prasad Received on Fri Aug 14 1998 - 00:00:00 CEST