I use Microsoft SQL Server 2008 and got an error message for the query below:
select * from conthist
WHERE (Conthist.REF LIKE '%Are you ready for John's Next Single%')
The error message is:
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near 's'.
Msg 105, Level 15, State 1, Line 2
Unclosed quotation mark after the character string ')