I found it 🙂

here is the solution

public string mySTRING (string singleQ){

return singleQ.Replace(" ' ", " ' ' ");

}

SELECT ID, Title

FROM viewTopTitles

WHERE Title = mySTRING (you're most welcome)

SOURCE : http://www.sqlfr.com/forum/sujet-PROBLEME-AVEC-APOSTROPHE_1349006.aspx

info : the forum is in French lang but you should see the full code there probably understand 🙂