Insert Statement from mySQL

[AndreasMet]

Hi All,
I cannot find the answer to a simple question.

I have a table with a field defined as text. This field stores a number of SQL statements that are called upon to be executed on a dataset.

The problem I have is loading a record into the table when the SQL statement has a ' in it. For eaxample:

INSERT INTO TABLE 'tblStoredSQL' values ('SELECT * FROM tblJunk WHERE name = 'example'')

The insert statement requires the use of the ' and the stored SQL statement has the ' in it as well.

What to do?

Thanks for responses.

[AndreasMet]

Just use " instead of ' and it all works.

Problem solved.