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.
>

Reply via email to