replace with -SELECT * FROM ClauseTranslations WHERE Clause LIKE 'trainee**''**s cost' the error occured because of 's so,u better replace ''s instead of 's