Inserting a value with an apostrophe?

[Quoted] Can anyone tell me how to get around the error that occurs when an value being inserted into a field has an apostrophe in it. The SQL insert statement thinks the apostrophe is the end of the statement and crashes.

Ex. INSERT INTO EMP (EmpName) VALUES ('Jeff's Name');

It doesn't like the apostrophe in "Jeff's"

Thanks

Jeff Received on Fri Feb 02 2001 - 01:02:34 CET