Inline variable with % wildcard

460
1
10-28-2011 08:18 AM
AustinStreetman
New Contributor III
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
0 Kudos
1 Reply
ShitijMehta
Esri Regular Contributor
Check this forum thread and and see if the post on 09-08-2011 09:05 AM in this thread answers your question.
0 Kudos