on binding NULL/undef values > > > On Wed, 13 Feb 2002 18:03:07 -0500, Jeff Urlwin wrote: > > >With SQL Server 2000 and DBD::ODBC, > > col_a = null returns no rows
The point was that col_a is a column, and I would have thought, given the original post, that it would search for values within col_a being null and it didn't. > > (null = null) is always false > > > col_a is null returns 1 row > > so that's the one you want, I assume? Yes, there was one row with a null in col_a > > > ? is null (passing col_a) returns 0 rows > > The value "col_a" is not null, obviously. Right. > > -- > Bart. >