Getting null values by using is null statement

Question

1.00/5 (2 votes)

See more:

if we have table A with Column Column1
i know that if we want to take the rows with null value for Column1 we
use the query
Select * From A
Where Column1 Is Null

And not the query
Select * From A
Where Column1 = NULL

but if i want to use the condition Column1= Null and want it to give the same result as Column1 Is Null
Is there any sql configurations Or Parameters that should be set to on
to make me able to use this query or there is none

What I have tried:

I have tried to put a question about using is null statement in sql server

Posted 8-Mar-16 21:55pm

oula alsheikh

Updated 9-Aug-16 22:51pm

Add a Solution

Comments

Tomas Takac 9-Mar-16 4:00am

Why? You can set SET ANSI_NULLS OFF[^] but I would advise against that.

Richard Deeming 9-Mar-16 6:52am

You should post this as a solution. :)

oula alsheikh 9-Mar-16 8:48am

thanks for info

CHill60 9-Mar-16 7:19am

Why on earth do you want to say Column1 = Null ?
What are you really trying to do?

oula alsheikh 9-Mar-16 8:51am

if we want to compare variable value with null we have to test if this variable is null first to use the is null condition in the clause
while you dont have to when using = operator in usual

CHill60 9-Mar-16 9:06am

Then try something like WHERE ISNULL(Column1,'Ignore') = 'Ignore'

Tomas Takac 9-Mar-16 14:25pm

NULL is a special value thus deserves special treatment. Do you have a real-life problem you are trying to solve?

RedDk 10-Mar-16 13:18pm

Yeah but here's the problem with "special value" ... THIS question I asked back in Jan '15 might be resolved a little more.

http://www.codeproject.com/Questions/867041/How-to-set-ANY-field-in-system-catalog-using-code

Tomas Takac 10-Mar-16 16:03pm

I read your question and I don't understand what it is about. But it doesn't seem to be related to this one. Sorry.

RedDk 10-Mar-16 16:07pm

No problem ... thanks

RedDk 10-Mar-16 13:29pm

It's not my intention to hijack this thread. Sorry if my question is a little esoteric. PB deemed it as such and I'm still trying to recover from the snubb. ;)

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 11114915 - Tanvi · Answer 1 · 2016-08-09T22:51:00

Null value in a column of a row means there is no value present for that cell.
"where column1=Null" - This condition means that there is some value which is "Null" and that value ="Null" is not present and hence no result comes.
"where column1 is Null" - In this condition, rows which does not have any value for column1 are searched and hence it fetches the result.