At 12:35 AM 11/27/2004, Namit Nathwani wrote:

>UPDATE RDB$RELATION_FIELDS SET RDB$DESCRIPTION = 'Bhavbhuti's notebook'
>WHERE RDB$RELATION_NAME = 'ACCOUNTS' AND RDB$FIELD_NAME = 'REMARKS';
>
>I have tried to replace 'Bhavbhuti's notebook' with "Bhavbhuti's notebook"
>and [Bhavbhuti's notebook] just in case I am allowed to use the ', but no
>luck.
>
>I have also tried 'Bhavbhuti\'s notebook', 'Bhavbhuti\\'s notebook',
>'Bhavbhuti/'s notebook' and 'Bhavbhuti//'s notebook' but still no luck.

The correct (standard compliant) way to enter a single quote mark in
a SQL string value is to double it: 'Bhavbhuti''s notebook'

Regards,


Ann