>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 '%''%'
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.