topic Inline variable with % wildcard in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/inline-variable-with-wildcard/m-p/535504#M17758 <HTML><HEAD></HEAD><BODY><SPAN>In Model Builder, is there a way to use inline variable substitution with an itterator to construct a select statement that contains the ???%??? wildcard? In otherwords, is there a way to turn off the percent sign so that it goes through and is used as a wildcard in the SQL statement instead of functioning as the dereferencing operator for the inline variable? I tried this: [FIELDNAME] LIKE \%%Value%\%</SPAN><BR /><BR /><SPAN>See attached screenshot</SPAN></BODY></HTML> Fri, 28 Oct 2011 15:18:58 GMT AustinStreetman 2011-10-28T15:18:58Z Inline variable with % wildcard https://community.esri.com/t5/geoprocessing-questions/inline-variable-with-wildcard/m-p/535504#M17758 <HTML><HEAD></HEAD><BODY><SPAN>In Model Builder, is there a way to use inline variable substitution with an itterator to construct a select statement that contains the ???%??? wildcard? In otherwords, is there a way to turn off the percent sign so that it goes through and is used as a wildcard in the SQL statement instead of functioning as the dereferencing operator for the inline variable? I tried this: [FIELDNAME] LIKE \%%Value%\%</SPAN><BR /><BR /><SPAN>See attached screenshot</SPAN></BODY></HTML> Fri, 28 Oct 2011 15:18:58 GMT https://community.esri.com/t5/geoprocessing-questions/inline-variable-with-wildcard/m-p/535504#M17758 AustinStreetman 2011-10-28T15:18:58Z Re: Inline variable with % wildcard https://community.esri.com/t5/geoprocessing-questions/inline-variable-with-wildcard/m-p/535505#M17759 <HTML><HEAD></HEAD><BODY><SPAN>Check this </SPAN><A href="http://forums.arcgis.com/threads/39011-Expression-substitution-using-wildcards-and-variables?highlight=Shitijmehta">forum thread</A><SPAN> and and see if the post on 09-08-2011 09:05 AM in this thread answers your question.</SPAN></BODY></HTML> Fri, 28 Oct 2011 15:44:54 GMT https://community.esri.com/t5/geoprocessing-questions/inline-variable-with-wildcard/m-p/535505#M17759 ShitijMehta 2011-10-28T15:44:54Z