Having trouble w/ NULL 1

[Olivia123]

I was wondering if I can wright something like this....

 a.CALL_CC IS BETWEEN NULL AND b.CA_CC1

This is actually the logic that I need, but, it won't work , is there any other way I can wright it, and use this logic.

Thank you

 

[PHV]

Which logic ?
Consider NULL as unknown and explain us which logic may determine if a value is between an unknown value and another value.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Olivia123]

Is there anyway I can set the null value as '0' or '1' ?

 

[PHV]

In fact, you want something like this ?
WHERE (a.CALL_CC IS NULL OR a.CALL_CC BETWEEN 0 AND b.CA_CC1)

Or this ?
WHERE COALESCE(a.CALL_CC, 0) BETWEEN 0 AND b.CA_CC1)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Olivia123]

Thank you, the second one helped me out, I wasn't familiar with COALESCE