Where statement when field contains quotes

[Davecarlin71]

Hi

I am writing a report and bringing in a QVD and using that to show only entries where equals the following text

Call reactivated As 'Comp Awtg Com.'

I can't add the usual quotes marks round it as it is reading the ones in the text. I have tried using " marks and [ but I doesn't work.

Please can anyone help.

Thanks

Dave

[sunny_talwar]

How about if you do it like this

Where Match(Replace(FieldName, Chr(39), '#'), 'Call reactivated As #Comp Awtg Com.#')

[Davecarlin71]

Fantastic thankyou so much 👍👍👍😁