Re: Informix Certified Professional Program

Jonathan Leffler wrote: > > }From: Ian Goddard <igoddard@netcomuk.co.uk> > }Date: Wed, 12 Feb 1997 01:06:47 -0800 > }X-Informix-List-Id: <news.33791> > } > }Walter S. Tyszka wrote: > } > }> According to Informix: NULL means unknown, so comparing anything to NULL > }> will evaluate as true - since you can not tell for sure whether the two > } ^^^^ > }Since when? We went over this a few months ago. It evaluates to false. > ^^^^^ > Since when? I went over this earlier today, and it evaluates to unknown! > > }> values are different. This reminds me of a bug [feature? :) ] in 4.11 (& wherever else) where if a string starts with a numeric e.g. "3hello" (or is null, not sure about "0"), it evaluates to false, otherwise true in syntax like: if stringvar then call dothis() end if Douglas Wilson