using an Apsotrophe in a string-HOW?

[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' || '''';