Quotes in SQL

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?

For any SQL text field being used in a statement always use the following:

Code:

---

myFielddata = Replace(myFielddata, "'", "''")

---

:cool:

thanks