> Philip Arnold said:
>>
>> And in the opposite, because NULL is a different "state", you
>> can't treat it like 1 or 0, so you have to do:
>> WHERE prov is NULL or prov = 0
>
> WHERE NOT prov IS NULL OR prov = FALSE
Obviously the NOT is not needed here.
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
