using an Apsotrophe in a string-HOW?

[johng]

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

[marist89]

INSERT INTO TABLE (STRING_COLUMN)
VALUES( 'BOB''S');

[jdorlon]

If the quote is to be at the end of the string then use 3 :

string_var := 'It is 'Bobs''';

this also works at the beginning of a string as in :

string_var := 'It is Bob' || '''s';

If you just need an apostrophe all by itself then use 4 :

string_var := 'It is Bobs' || '''';