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 🙂