SELECT *
FROM [aTable]
WHERE [aTable].[aField] <> 'thing'
The query is returning most of the results where [aField] is not equal to 'thing'. But, it's also not returning results where [aField] IS NULL. Doesn't this mean that the query is thinking that "thing" = IS NULL?
FROM [aTable]
WHERE [aTable].[aField] <> 'thing'
The query is returning most of the results where [aField] is not equal to 'thing'. But, it's also not returning results where [aField] IS NULL. Doesn't this mean that the query is thinking that "thing" = IS NULL?