>>>This doesn't work for obvious reasons. I'm trying to find all records that have an apostrophe in the DocumentName field.
>>>

>>>WHERE H.DocumentName LIKE '%'%'
>>>

>>
>>Just double it:
>>

>>WHERE H.DocumentName LIKE '%''%'
>>

>
>I'm sure it works, but what is the logic with that? That makes no sense to me at all.

Usually single apostrophe is used as a string terminators (I am not sure about if that term is right). So how to use apostrophe inside the string? There must be a way to let T-SQL know that this apostrophe is not a terminator but a regular char. MS decides to use double apostrophes for that.