I want to use SQL to enter a string into a field.

the string is BOB'S

now how do i do this?

if i say
INSERT INTO TABLE (STRING_COLUMN)
VALUES( 'BOB'S');

It doesn't work.

Any ideas?

TIA,

JOHN