Re: Compare variables / NULL syndrome

I've used this before:

        if (0 || var_a = 0 || mytab.z) and
           (0 || var_b = 0 || mytab.y) and
           ...
           (0 || var_z = 0 || mytab.a) then

Hope this helps.

    Alton

Sam Jordan wrote:

> First I have done it the following way, something like
>
> if (var_a = mytab.z) and
> (var_b = mytab.y) and
> ...
> (var_z = mytab.a) then
>
> Problem: if both parameter and table element are null, then
> this comparison will result to 'not true', although both results
> are the same.
Received on Mon May 17 1999 - 15:43:14 CDT