topic How to Select by attribute that &quot;contains&quot; a particular number in Data Management Questions https://community.esri.com/t5/data-management-questions/how-to-select-by-attribute-that-quot-contains-quot/m-p/149514#M8448 <HTML><HEAD></HEAD><BODY><P><SPAN>Hello,</SPAN><BR /><SPAN> How is it possible to make a "select by attribute" for numbers but numbers contained in the attribute? </SPAN><BR /><SPAN> I would like to select all the attributes that contains the number '16777'. Sometimes it's only '16777' so very easy, but sometimes it's '16857 | 18754 | 16777'</SPAN><BR /><SPAN> How can I do to make a select attributes that "contains" the number '16777'?</SPAN><BR /><BR /><SPAN> Thanks a lot.</SPAN></P></BODY></HTML> Mon, 09 Dec 2013 08:10:43 GMT PascalineWallemacq 2013-12-09T08:10:43Z How to Select by attribute that "contains" a particular number https://community.esri.com/t5/data-management-questions/how-to-select-by-attribute-that-quot-contains-quot/m-p/149514#M8448 <HTML><HEAD></HEAD><BODY><P><SPAN>Hello,</SPAN><BR /><SPAN> How is it possible to make a "select by attribute" for numbers but numbers contained in the attribute? </SPAN><BR /><SPAN> I would like to select all the attributes that contains the number '16777'. Sometimes it's only '16777' so very easy, but sometimes it's '16857 | 18754 | 16777'</SPAN><BR /><SPAN> How can I do to make a select attributes that "contains" the number '16777'?</SPAN><BR /><BR /><SPAN> Thanks a lot.</SPAN></P></BODY></HTML> Mon, 09 Dec 2013 08:10:43 GMT https://community.esri.com/t5/data-management-questions/how-to-select-by-attribute-that-quot-contains-quot/m-p/149514#M8448 PascalineWallemacq 2013-12-09T08:10:43Z Re: Select by attribute "contains" https://community.esri.com/t5/data-management-questions/how-to-select-by-attribute-that-quot-contains-quot/m-p/149515#M8449 <HTML><HEAD></HEAD><BODY><SPAN>Pascaline,</SPAN><BR /><BR /><SPAN>Lets say your attribute is NUMBER, just use the following code in your "Select By Attribute":</SPAN><BR /><BR /><STRONG>NUMBER LIKE '%16777%'</STRONG><BR /><BR /><SPAN>With this there can be anything infront or after 16777, the % is your wildcard.</SPAN><BR /><BR /><SPAN>Hope this helps!</SPAN><BR /><BR /><SPAN>Tim</SPAN></BODY></HTML> Mon, 09 Dec 2013 11:25:35 GMT https://community.esri.com/t5/data-management-questions/how-to-select-by-attribute-that-quot-contains-quot/m-p/149515#M8449 TimWitt 2013-12-09T11:25:35Z Re: Select by attribute "contains" https://community.esri.com/t5/data-management-questions/how-to-select-by-attribute-that-quot-contains-quot/m-p/149516#M8450 <HTML><HEAD></HEAD><BODY><SPAN>Thanks a lot Tim, now it works very well!!</SPAN></BODY></HTML> Mon, 09 Dec 2013 11:51:22 GMT https://community.esri.com/t5/data-management-questions/how-to-select-by-attribute-that-quot-contains-quot/m-p/149516#M8450 PascalineWallemacq 2013-12-09T11:51:22Z Re: Select by attribute "contains" https://community.esri.com/t5/data-management-questions/how-to-select-by-attribute-that-quot-contains-quot/m-p/149517#M8451 <HTML><HEAD></HEAD><BODY><SPAN>No problem! Don't forget to mark the answer, by clicking the grey check mark on the right <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></SPAN></BODY></HTML> Mon, 09 Dec 2013 11:52:51 GMT https://community.esri.com/t5/data-management-questions/how-to-select-by-attribute-that-quot-contains-quot/m-p/149517#M8451 TimWitt 2013-12-09T11:52:51Z