hi all i have the below inside the SQL statement '(case when transaction.ToSubsidiary IS NOT NULL then 'TRUE' end) as Eliminate,' in which there is 'TRUE' which is also having single quotes. i want to escape this single quote inside the single quote. How to do this?

Thank you