Jon Stephens <[EMAIL PROTECTED]> 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 ./ [EMAIL PROTECTED] ./ koniec i bomba, a kto czytal ten traba. w.g. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]