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?