> Hi all
>
> I am trying to update the description of fields and tables quite
> successfully. Thanks to Dorin and all other who have helped me with it.
>
> Now I am trying to write a description with and apostrophe (') in
> the text
> and this doesn't work. For eg.
>
> 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.
>
> Just for record I am doing this from VFP via ODBC from a Table Builder I
> have created. It allows creation of FB and VFP tables using the same VFP
> interface. It is almost done, so just in case anybody wants to
> have a try
> just let me know I can send a copy.
>
> Please advise.
>
>
>
>
> Regards
> Bhavbhuti

You haven't tried
'Bhavbhuti''s notebook'

Alan