Handling Apostrophe in Dynamic SQL

Its always difficult to handle Apostrophe  in SQL queries and when its dynamic query then its become too difficult.