How to escape single quotes in Firebird 2.5 in where clause of select statement

Question

How do I get this to work?

select * from table where column like '%situation = 'C'%'

Answer 1

To escape an apostrophe you need to double it see manual

 select * from table where column like '%situation = ''C''%'