topic ModelBuilder: How to create a layer with only numeric values in a text field in ModelBuilder Questions https://community.esri.com/t5/modelbuilder-questions/modelbuilder-how-to-create-a-layer-with-only/m-p/830473#M1344 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>In ModelBuilder I am looking to make a Feature Layer&nbsp;selecting values from &nbsp;feature class where a field&nbsp;ProjectNumber has only numeric values not alphanumeric. The field is declared as text.</P></BODY></HTML> Thu, 06 Dec 2018 16:06:07 GMT JoseSanchez 2018-12-06T16:06:07Z ModelBuilder: How to create a layer with only numeric values in a text field https://community.esri.com/t5/modelbuilder-questions/modelbuilder-how-to-create-a-layer-with-only/m-p/830473#M1344 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>In ModelBuilder I am looking to make a Feature Layer&nbsp;selecting values from &nbsp;feature class where a field&nbsp;ProjectNumber has only numeric values not alphanumeric. The field is declared as text.</P></BODY></HTML> Thu, 06 Dec 2018 16:06:07 GMT https://community.esri.com/t5/modelbuilder-questions/modelbuilder-how-to-create-a-layer-with-only/m-p/830473#M1344 JoseSanchez 2018-12-06T16:06:07Z Re: ModelBuilder: How to create a layer with only numeric values in a text field https://community.esri.com/t5/modelbuilder-questions/modelbuilder-how-to-create-a-layer-with-only/m-p/830474#M1345 <HTML><HEAD></HEAD><BODY><P>Jose,</P><P></P><P>This is covered a bit here <A _jive_internal="true" href="https://community.esri.com/thread/219202-arcgis-pro-how-to-query-a-text-field-with-a-numeric-operator">ArcGIS Pro: how to QUERY a text field with a numeric operator</A>.</P><P></P><P>Try:&nbsp;<SPAN style="background-color: #ffffff; border: 0px;">CAST(<SPAN>ProjectNumber&nbsp;</SPAN>AS&nbsp;</SPAN><SPAN style="background-color: #ffffff; border: 0px;">INTEGER</SPAN><SPAN style="background-color: #ffffff; border: 0px;">)&nbsp;</SPAN><SPAN style="background-color: #ffffff; border: 0px;">&gt;</SPAN><SPAN style="border: 0px; background-color: #ffffff; font-weight: inherit; ">&nbsp;50 (use whatever operator and number you wish)</SPAN></P><P></P><P></P><P>Jake</P></BODY></HTML> Wed, 24 Apr 2019 11:37:34 GMT https://community.esri.com/t5/modelbuilder-questions/modelbuilder-how-to-create-a-layer-with-only/m-p/830474#M1345 JakeSimms1 2019-04-24T11:37:34Z