I believe that %' is an escape character in SQL that says to the DB to process it as a ' instead of the end of a string since thats what 's are usually used for. The ' was saying the string was over and the DB couldn't match the normal ' at the end to anything so it failed. You can also do the same thign for a few other special characters, like %% inserts a %. And I could be completely wrong of course, but I do beleive from my SQL class two years ago that is the right way to do it.
|