single quotes are removed, rather than escaped #31
Description
Single quotes should be escaped, rather than removed - a SQL command errored because 2,2-DDT wasnt in the lookup list (should have been 2,2'-DDT (and the quote should have been doubled up to escape it