Apostrophe's and Quotation Marks in where condition Like in SQL Server

Apostrophe

's and Quotation Marks in where condition Like in SQL Server

put '' two double single quote

select

description,* from genres where description like '%''s %'