Not null function in sql server 2008

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve?

Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. It would then match names that did not exist in table2 because of the null values.

Meaning that this would return 0 results. And if I did:. It has nothing to do with collation. The reason is that when you try to compare something to NULL e. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?

Collectives on Stack Overflow. Learn more. Asked 10 years, 1 month ago. Active 10 years, 1 month ago. Viewed 2k times. Can anyone explain why this happens? Maybe something with set theory? Add a comment.

Active Oldest Votes. I don't think collation even enters into it, the queries are different. Community Bot 1 1 1 silver badge. Sign up or log in Sign up using Google.