I am getting an error with my SQL when someone tries to register some details on my website. I am using ASP with a MySQL Database.
The Error is as follows:

INSERT INTO table1 values('Sam's','Place', NULL)

You have an error in your SQL syntax near 's Place', NULL)' at line 1

The error is being caused by the apostrophe in sam's.

How can I resolve this ?