Subject | how NULL compares |
---|---|
Author | d_dude_2003 |
Post date | 2005-09-01T15:49:12Z |
Hi there guys,
I have a table like
ID INTEGER
TIMEIN TIME
TIMEOUT TIME
populates with records like
1 Time1 <Null>
2 <Null> Time2
3 Time3 <Null>
4 <Null> Time4 etc.
If i use
SELECT *
WHERE (TIMEIN > Param1) AND (TIMEIN < Param2) AND (TIMEOUT > Param1)
AND (TIMEOUT < Param2)
will it return the right records and NULL is not being compared here?
Hope u get it :)
Thanx alot,
Eugene.
I have a table like
ID INTEGER
TIMEIN TIME
TIMEOUT TIME
populates with records like
1 Time1 <Null>
2 <Null> Time2
3 Time3 <Null>
4 <Null> Time4 etc.
If i use
SELECT *
WHERE (TIMEIN > Param1) AND (TIMEIN < Param2) AND (TIMEOUT > Param1)
AND (TIMEOUT < Param2)
will it return the right records and NULL is not being compared here?
Hope u get it :)
Thanx alot,
Eugene.