I think what you're trying to do is insert a SQL string into a varchar text field.

You have to replace all the single quotes with '' to escape them [that's 2 single quotes]

Like so:

INSERT INTO

FOOD(Query)

VALUES

('Wheatie''s')