Re: Null bind variable in where clause

Hello Chris,

Another approach is ... WHERE (b=?) IS TRUE or
... WHERE (b=?) IS NOT FALSE
depending which behavior you want when b IS NULL.



Monday, April 30, 2007, 6:34:56 PM, you wrote:

> It looks like you can not use a bind variable when trying to match null
> in a where clause.  Is there any way to get the desired effect without
> having to remove the bind variable and rewrite the query to "WHERE b IS
> null"?