I need to insert text into a database using SQL which has single quotes (') in - but every time I try I can't do it because it conflicts with the quotes used in the SQL command:
INSERT INTO Table (Field) VALUES ('hello, it's a nice day')
The quote in the word " it's " causes an error. Does anyone now how to add a quote?
