Firebird and the problem of the apex

Can exist in Firebird records in which the apex appears: for example in CITTA'. In these cases Firebird does not accept the field. In order to avoid the problem you must double the apex. The function Replace for ex. can for this purpose be used in this way: “update Table set Field='" & Replace (Textbox1.text, "'", "''") & "'"