hi table:
name varchar(10) fruit integer i want to write an sql statement like this: select fruit from table which should return 'good' if fruit = 1 and 'bad' if fruit =2 and 'rotten' if fruit =3 can it be done? kg ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
