topic Re: PLZ help me in working with null values in a table in ArcObjects SDK Questions https://community.esri.com/t5/arcobjects-sdk-questions/plz-nbsp-help-me-in-working-with-null-values-in-a/m-p/499613#M13418 <HTML><HEAD></HEAD><BODY><SPAN>This is not really the right forum but I can answer.&nbsp; Your fields are not null they have an empty string.&nbsp; Empty strings and null are not the same thing from a database perspective.&nbsp; If your fields were truly null they would show &lt;Null&gt; in the field. </SPAN><BR /><SPAN>try:</SPAN><BR /><SPAN>[Field_name] = ''&nbsp; (two single quotes)</SPAN></BODY></HTML> Fri, 30 Sep 2011 18:54:15 GMT AlexanderGray 2011-09-30T18:54:15Z PLZ  help me in working with null values in a table https://community.esri.com/t5/arcobjects-sdk-questions/plz-nbsp-help-me-in-working-with-null-values-in-a/m-p/499612#M13417 <HTML><HEAD></HEAD><BODY><SPAN>Hello everybody,</SPAN><BR /><BR /><SPAN>First of all, I do not know if it's the right section to post such a topic</SPAN><BR /><BR /><SPAN>Anyway,I need help in working with null values in a table. I have a table in which I want to create query - in "select by attribute" window- about &lt;NULL&gt; values, So my query is:</SPAN><BR /><BR /><SPAN>SELECT * from Table_name where</SPAN><BR /><SPAN>[Field_name] IS NULL</SPAN><BR /><BR /><SPAN>but no record is selected even though the table contain lots of &lt;NULL&gt; values (see attached image)</SPAN><BR /><BR /><SPAN>What could be the problem?</SPAN></BODY></HTML> Fri, 30 Sep 2011 18:23:37 GMT https://community.esri.com/t5/arcobjects-sdk-questions/plz-nbsp-help-me-in-working-with-null-values-in-a/m-p/499612#M13417 MOHAMMEDHABBOUB 2011-09-30T18:23:37Z Re: PLZ help me in working with null values in a table https://community.esri.com/t5/arcobjects-sdk-questions/plz-nbsp-help-me-in-working-with-null-values-in-a/m-p/499613#M13418 <HTML><HEAD></HEAD><BODY><SPAN>This is not really the right forum but I can answer.&nbsp; Your fields are not null they have an empty string.&nbsp; Empty strings and null are not the same thing from a database perspective.&nbsp; If your fields were truly null they would show &lt;Null&gt; in the field. </SPAN><BR /><SPAN>try:</SPAN><BR /><SPAN>[Field_name] = ''&nbsp; (two single quotes)</SPAN></BODY></HTML> Fri, 30 Sep 2011 18:54:15 GMT https://community.esri.com/t5/arcobjects-sdk-questions/plz-nbsp-help-me-in-working-with-null-values-in-a/m-p/499613#M13418 AlexanderGray 2011-09-30T18:54:15Z