This is a kind of stupid question. I created a new field in one of the table, ActivityStatus. The value in that field is NULL.
When I do the SELECT * FROM MyTable WHERE ActivityStatus <> 'CLOSED'
It returns 0. Why is that? I though it should have returned everything? thanks