Values <> null

Question

Post reply

Values <> null

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736445 More actions · Answer 1

We can't edit the question in email. If we find an issue, it's corrected on the site.

sdorris-1150234 SSC-Addicted Points: 457 More actions · Answer 2

Ahhhh...that's why you call us McNewbie's. 🙂 Great site, and great editorials. Look forward to seeing them every day.

lloyd-236007 SSC Enthusiast Points: 197 More actions · Answer 3

yes actually i had that question with default settings in mind, but its good to see so many responses as i know it has actually set minds thinking and after all thats the objective.

In future i will include things like this.

John McC Hall of Fame Points: 3410 More actions · Answer 4

Remember:

Never assume anything because it can make a donkey out of u and me

Won't let me SUBSTRING('assume',1,3) 😀

-------------------------------------------------------------------------
Normal chaos will be resumed as soon as possible. :crazy:

amit_adarsh Ten Centuries Points: 1273 More actions · Answer 5

its all about the database setting of ANSI_NULLS

Set ANSI_NULLS off / on

But by default database settings for ANSI_NULLS is ON so you will get nothing .

zymos SSCommitted Points: 1960 More actions · Answer 6

Interesting topic, yet confusing at times when determining times to set the ANSI_NULL to ON or OFF to yield expected results. Thanks.

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 7

select * from ##TableNulls where col2 is not null

will give out the expected results at fist sight

Thank you for the question

Igor Micev,My blog: www.igormicev.com