Ignores null values !!!
I have a datafield with values "ABC", " ", and NULL.
When I query value <> "ABC", it retrieves " ", but ignores the null values.
Is there any settings to be done on Database property so that the query will also include null values?
Please post questions to the forums, where others may benefit.
I do not offer free assistance by e-mail. Thank you!
It would probably help to see your SQL statement but I will take a stab:
...AND datafield IS NULL
Typically any comparison, other than the format above, against a NULL value will result in a False result.
Microsoft MVP (Visual Basic)
SQL 2000 Query
Originally Posted by Phil Weber
It is SQL 2000.
Hi. You can use the ISNULL function.
For example, isnull(value, 0) will return zeros where value is equal to null. Just remember what you set your nulls to so you can interpret you results correctly.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center