Hello all, i'm trying to do a search on the Price Level that contains '%'. But when i'm trying to put \% to escape but it's not working. any ideas ? thanks a lot.

Did you try without the backslash too?

yes. I found the solution.

case when {pricelevel} like '%\%' ESCAPE '\'  THEN 1 else 0 end