Your "WHERE" in part should look like this:

WHERE COL_1 NOT LIKE '%''%'