Quotes in SQL

[rodders45]

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?

[Jerry Grant]

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

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

[rodders45]

thanks