• We can escape single quotes by preceding it with an extra quote. see below

    http://sqlblogcasts.com/blogs/madhivanan/archive/2008/02/19/understanding-single-quotes.aspx