Simple SQL (1 Viewer)

I have a simple piece of SQL which changes something when something else starts with PQ:


I want to change this to do it when it contains PQ (AAPQBB or AAABBPQ or PQAABB etc.), I am sure the answer is pretty obvious but have spent a whole day trying different possibilities.

Any help would be greatly appreciated.

Put another * in front of PQ

Many thanks for that, it was the first thing I tried yesterday and I had tried every possible variation thereafter on the assumption that it didn't work.

Somebody confirming that it was correct made me look a bit further and I found it was being removed later in the code for a different reason.

Trouble is, when you are not sure something is working you get a bit of tunnel vision.