>>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.