Helmut44

Expression substitution using wildcards and variables

Discussion created by Helmut44 on Sep 7, 2011
Latest reply on Sep 8, 2011 by Helmut44
I have a problem I can not somehow solve on my own: I am trying to make a Select Query in ModelBuilder, using a substitution of a User-Input String and an Expression with Wildcards. The problem is, that I need to use the %-Wildcard, and thats the same as for the string-substitution.
This one works:
"Tags" LIKE '%music%' whereas this one works not (with the input-string):
"Tags" LIKE '%%string%%'

I tried all sorts of combinations, like
"Tags" LIKE '%'%string%'%'
"""Tags" LIKE '%"""%string%"""%'"""

but it is giving me errors all the time. Do you know the correct format of this query?

Outcomes