https://community.esri.com/t5/arcgis-survey123-questions/how-to-select-only-values-less-that-43/m-p/1516378#M58377 <P>The concat function is for text data, which cannot accurately be compared to numeric data. Is the proposed_meter_sequence column stored as integer or text?</P> Wed, 07 Aug 2024 21:54:02 GMT TonyContreras_Frisco_TX 2024-08-07T21:54:02Z https://community.esri.com/t5/arcgis-survey123-questions/how-to-select-only-values-less-that-43/m-p/1516333#M58373 <P>Good afternoon</P><P>&nbsp;</P><P>, concat('SequenceNo=', ${proposed_meter_sequence}, ' and ', ${proposed_meter_sequence}, '&lt;=43' ))</P><P>&nbsp;</P><P>I am looking for a way to select&nbsp; &nbsp;proposed_meter_sequence values that are less than 43.&nbsp; I tried the&nbsp; syntax above but it does not work.</P><P>Please advise.</P><P>&nbsp;</P> Wed, 07 Aug 2024 19:55:49 GMT https://community.esri.com/t5/arcgis-survey123-questions/how-to-select-only-values-less-that-43/m-p/1516333#M58373 JoseSanchez 2024-08-07T19:55:49Z https://community.esri.com/t5/arcgis-survey123-questions/how-to-select-only-values-less-that-43/m-p/1516378#M58377 <P>The concat function is for text data, which cannot accurately be compared to numeric data. Is the proposed_meter_sequence column stored as integer or text?</P> Wed, 07 Aug 2024 21:54:02 GMT https://community.esri.com/t5/arcgis-survey123-questions/how-to-select-only-values-less-that-43/m-p/1516378#M58377 TonyContreras_Frisco_TX 2024-08-07T21:54:02Z https://community.esri.com/t5/arcgis-survey123-questions/how-to-select-only-values-less-that-43/m-p/1516384#M58378 <P>Hi <a href="https://community.esri.com/t5/user/viewprofilepage/user-id/406743">@TonyContreras_Frisco_TX</a>&nbsp;</P><P>&nbsp;</P><P>The proposed_meter_sequence column is stored as an integer.&nbsp; In this case how do I only select values&nbsp; &lt;= 43?</P><P>Thanks</P> Wed, 07 Aug 2024 22:11:04 GMT https://community.esri.com/t5/arcgis-survey123-questions/how-to-select-only-values-less-that-43/m-p/1516384#M58378 JoseSanchez 2024-08-07T22:11:04Z