Like operator not working with parameter

[maltahan]

I am trying to use the like operator with a parameter using 'add string parameter' action, but it seems to be that the like operator is considering my parameter as a string and not as a parameter. Hier is an example:
and doc.Name like ''%$text%'''.

[ArjenLammers]

Hi Maltahan,

Try removing the "
So LIKE %$test%

Does that work?

[maltahan]

Hello Arjen

Unfortunately, it throws an error, since the like operator expects the ''. Here is the error: 'Error on line 7 character 111: extraneous input '%' expecting {NULL, TRUE, FALSE, NATURAL, REAL, VARIABLE, STRING_LITERAL}
Error on line 7 character 117: mismatched input '%' expecting {, ';'}'