Re: NULL comparisions

> Hi,
>
> How do I check if two textboxes (say box1 and box2) are both empty. I am
> testing for equality.
> Apparently even if both are empty, they are still not considered equal. So
> if (box1 = box2) always
> returns false when both boxes are empty. I want it to return true. Is
> there a special check for null values?
>
> Thanks.

try

select...
from...
where

    (box1 = box2) or
    (box1 is null and box2 is null)

Hope this will help, let me know.

Regards, Stephan

--
---------------------------------------------------------------
Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-17          | Landsberger Allee 392
fax: +49 30 549932-29          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------