AustinStreetman

Inline variable with % wildcard

Discussion created by AustinStreetman on Oct 28, 2011
Latest reply on Oct 28, 2011 by smehta-esristaff
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%\%

See attached screenshot

Attachments

Outcomes