topic Query out features with blank fields in ArcGIS Pro? in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/query-out-features-with-blank-fields-in-arcgis-pro/m-p/369839#M16187 <HTML><HEAD></HEAD><BODY><P>This seems like it should have an easy solution, but I can't for the life of me find it. I want to query out all features in a layer that do not have a value. I did not create the data, all the features already have their attributes filled in, and there is no "null" value in the blank field I want to query. If I try to just say FIELD is not null in the definition query, everything still shows up including all the features with blank FIELD.&nbsp;</P></BODY></HTML> Tue, 04 Aug 2020 19:43:52 GMT JuliaSurkis 2020-08-04T19:43:52Z Query out features with blank fields in ArcGIS Pro? https://community.esri.com/t5/arcgis-pro-questions/query-out-features-with-blank-fields-in-arcgis-pro/m-p/369839#M16187 <HTML><HEAD></HEAD><BODY><P>This seems like it should have an easy solution, but I can't for the life of me find it. I want to query out all features in a layer that do not have a value. I did not create the data, all the features already have their attributes filled in, and there is no "null" value in the blank field I want to query. If I try to just say FIELD is not null in the definition query, everything still shows up including all the features with blank FIELD.&nbsp;</P></BODY></HTML> Tue, 04 Aug 2020 19:43:52 GMT https://community.esri.com/t5/arcgis-pro-questions/query-out-features-with-blank-fields-in-arcgis-pro/m-p/369839#M16187 JuliaSurkis 2020-08-04T19:43:52Z Re: Query out features with blank fields in ArcGIS Pro? https://community.esri.com/t5/arcgis-pro-questions/query-out-features-with-blank-fields-in-arcgis-pro/m-p/369840#M16188 <HTML><HEAD></HEAD><BODY><P>Hi, I believe I had the same problem with a text field in the table. I was able to make my query from the table using the "Select by Attribute" tool at the top of the table. In the Select by Attribute dialog I selected "Add Clause", and in that dialog selected my Attribute Field, the comparison value ("is equal to", "is not equal to", etc.), then click on the little slider button marked SQL. In the SQL dialog that comes up, the Clause comes in built except for the value you want to use. In this case where there is no value, I used two single quotes (ex. '' ,with no space). This selected the empty values in the field I was querying.&nbsp;</P></BODY></HTML> Wed, 05 Aug 2020 00:35:10 GMT https://community.esri.com/t5/arcgis-pro-questions/query-out-features-with-blank-fields-in-arcgis-pro/m-p/369840#M16188 ChrisChandler1 2020-08-05T00:35:10Z Re: Query out features with blank fields in ArcGIS Pro? https://community.esri.com/t5/arcgis-pro-questions/query-out-features-with-blank-fields-in-arcgis-pro/m-p/1088910#M44430 <P>This works for me.</P> Fri, 13 Aug 2021 15:33:56 GMT https://community.esri.com/t5/arcgis-pro-questions/query-out-features-with-blank-fields-in-arcgis-pro/m-p/1088910#M44430 ElizabethWheeler 2021-08-13T15:33:56Z Re: Query out features with blank fields in ArcGIS Pro? https://community.esri.com/t5/arcgis-pro-questions/query-out-features-with-blank-fields-in-arcgis-pro/m-p/1113333#M47418 <P>out of curiousity i tried using the double single quotes, '' , for a definition query that was &lt;field&gt; is not equal to &lt;''&gt; - and that worked for me!&nbsp;</P><P>Thanks for the idea <a href="https://community.esri.com/t5/user/viewprofilepage/user-id/178005">@ChrisChandler1</a>&nbsp;</P> Tue, 02 Nov 2021 17:57:07 GMT https://community.esri.com/t5/arcgis-pro-questions/query-out-features-with-blank-fields-in-arcgis-pro/m-p/1113333#M47418 dshap1211 2021-11-02T17:57:07Z Re: Query out features with blank fields in ArcGIS Pro? https://community.esri.com/t5/arcgis-pro-questions/query-out-features-with-blank-fields-in-arcgis-pro/m-p/1306584#M70901 <P>I tried these steps, but errors. Tool must have been improved. Now, tool allows you to select "is null", apply, and OK. Then, I selected delete from above menu. Nulls removed. Nice and easy.<span class="lia-unicode-emoji" title=":beaming_face_with_smiling_eyes:">😁</span></P> Fri, 07 Jul 2023 16:43:50 GMT https://community.esri.com/t5/arcgis-pro-questions/query-out-features-with-blank-fields-in-arcgis-pro/m-p/1306584#M70901 stormec 2023-07-07T16:43:50Z