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

How do I get this to work?

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

Answer

To escape an apostrophe you need to double it see manual

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