SQL Error

[jamware]

I am trying to save custom reports to a table but I get a syntax error
due to the sinqle quotes.

How can I get around this error?

"INSERT INTO [MyReports] (ReportName, Report, Filter) Values
('test","CalDueListInfo_Query","(F12 = '21LR13' AND F22 = 'ON-SITE')")"

I want the User to be able to open saved report and apply the custom filter.

 

[jamware]

Hey all, I found my error.