Hello Alan,
NULL will not work in "IN" clause because SQL engine will evaluate NULL as unknown and that is the reason its not returning any null records.
There is excellent thread on StackOverflow to explain this.
Regards,
Vishal Patel
Blog: http://vspatel.co.uk
Site: http://lehrity.com
No comments:
Post a Comment