Re: Informix 4gl infant question

In article <CsJ7n4.4Av@nit.airtouch.com>, Mike Rogoff <miker@nit.airtouch.com> wrote: } Hi, if anyone could help me with the following question it would be } much appreciated (it's probably trivial). } } In a query comparing column names in a table to program variables } (with '='), the query seems to fail when the program variables are } NULL. Even if the column is null, the query doesn't match the row. } (Data type is char[]). } You can't use an "=" with NULL values... you must explicitly say WHERE colname IS NULL or WHERE colname IS NOT NULL DAS -- Dave Snyder @ Snide Computer Services - Folcroft, PA Current Release is db4glgen-3.19 UUCP: ..!uunet!das13!dave INTERNET: dave@das13.snide.com