On Fri, Dec 17, 2004 at 18:22:48 +0530,
Kenneth Gonsalves <[EMAIL PROTECTED]> wrote:
> On Friday 17 December 2004 06:12 pm, D'Arcy J.M. Cain wrote:
>
> > An alternative to Andreas' suggestion would be to create a simple lookup
> > table and join them. This is good if the real life example can g
On Fri, Dec 17, 2004 at 16:55:45 +0530,
Kenneth Gonsalves <[EMAIL PROTECTED]> wrote:
> 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'
On Friday 17 December 2004 06:12 pm, D'Arcy J.M. Cain wrote:
> An alternative to Andreas' suggestion would be to create a simple lookup
> table and join them. This is good if the real life example can get
> larger and/or the list can change and you don't want to modify code
> every time it does.
On Fri, 17 Dec 2004 16:55:45 +0530
Kenneth Gonsalves <[EMAIL PROTECTED]> wrote:
> 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
An alternative to Andreas' suggestion would be to
