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"?