Inserting a value that has an apostrophe in it....

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 Thu Feb 01 2001 - 17:47:36 CST