From: Johan De Meersman Date: March 15 2011 5:29pm Subject: Re: "IF" List-Archive: http://lists.mysql.com/mysql/224651 Message-Id: <695e5f4e-35ab-46c2-8215-da58e1d82466@zimbra> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable ----- Original Message ----- > From: "S=C3=A1ndor Hal=C3=A1sz" > > Yes, but Access s "IIF", of the same use, evaluates all three, and > the documentation explicitly says so. MySQL s, that I have seen, > says neither. Assuming the worst is safer, and then one uses CASE > ..., but if not, .... Well, they never have been very good at this whole "common sense" thing, ha= ve they. Sleep with the dog, get bitten by it's lice. > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel