Claus,

In IB6, dialect 3, IB will expect "O'Reilly" to be an identifier (column,
table etc) - so don't do this if you're thinking of upgrading.

Use the quote escape as documented: double single quotes: ''

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com



try this

INSERT INTO T ( ID, STR ) VALUES ( 1, "O'Reilly" )



ibfa2000 wrote:

>Hi,
>
>How can I write DML containing quotes, for example:
>
>INSERT INTO T ( ID, STR ) VALUES ( 1, 'O'Reilly' )
>
>Thanks,

[Non-text portions of this message have been removed]