http://cyprich.com/developer/using-an-apostrophe-in-a-variable-in-mssql/
Using an Apostrophe in a Variable in MSSQL