When I read through the question, I saw what looks like eight extra apostrophes, not just the one in the pronunciation helper for "Grisham". However, the extra apostrophes in Dean Koontz's biography are actually what Microsoft calls "smart quotes" - the ones that are slanted, not vertical, and T-SQL doesn't care about those (nor does it care about the slanted quotation marks that are in there as well). It does care about the one in the pronunciation guide, however, which is ironic, since another one in "Grisham''s first bestseller" was correctly doubled.
I thought that the extra apostrophes were going to generate the error message, and didn't notice the use of LEN with a TEXT column, so I got the right answer for the wrong reason. :hehe:
Thanks for the good question, Kshitij, but you should have actually tried it first in SSMS with the biography text before submitting it.