actual data in the field is Number of Bene's

among other things, this is the SQL I most recently tried

Delete from rcd_def_dtl

where rcd_prop_desc like '%''%'

errors returned

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near 's'.

Msg 105, Level 15, State 1, Line 3

Unclosed quotation mark after the character string ')

Updating the field only would be okay, but ultimately we would like to delete the whole record.

Thanks