Mask character in filter->Condition


I would like to know how to "mask" a character like & within the Condition of a filter.

eg:  my_filter->Condition= "!"My Text A & B" & !"Your Text C & D"";

Thanks in advance


I found a way to get rid of this problem for the moment, but that should NOT be the final solution.

I just replace all "special" characters that are used for controlling the filter functionality like (!=<>&;") and replace them with ? before adding the string to the filter condition.

Hi Wolfgang :-)

just set the condition to quotes. Like, condtion = ""C&A"";

And what about quotes within condition ?

Also prefix the quote with the escape char.