Re: IF() problem

[Przemyslaw Popielarski]

Jon Stephens <jon@stripped> wrote:
> *Any* string value evaluates as 0 (FALSE), not just the empty string.

Right. Didn't know that.
 
> You want "If BOOK1PL is not empty, return BOOK1PL, otherwise return
> BOOK1EN", correct?
> 
> Then try this instead:
> 
> SELECT IF(BOOK1PL <> '', BOOK1PL, BOOK1EN)
> FROM tBooksextra WHERE ksi = 'id';

Thanks, that is correct.

-- 
./ premax
./ premax@stripped
./ koniec i bomba, a kto czytal ten traba. w.g.