This is because quotation marks in SQL are done in pairs. In order to have a single quotation mark show up in your select statement it has to be escaped. The way to do this in T-SQL is by typing two single quotes.