I need to enter some data into a databse using SQL. However, how do you enter a value into a string which contains a quote?

I am using the normal INSERT statement ie
INSERT INTO table
VALUES (1, 2, 'Here's the problem', 4)
etc..

Answers on a postcard please?

Which DBMS? For Oracle the answer is to double up embedded quotes:

INSERT INTO table
VALUES (1, 2, 'Here''s the problem', 4)

(Note that that is two 's, not one ")

Same with Microsoft SQL Server