If you want to have a single-quote inside a literal string, use two consecutive single quotes, like this:
values( 1,'D''Alessio', 'Maria')
Quote:
Originally Posted by ursx
Hi all
i have following problems with literals
id = 1
vname = Maria
lname = D'Alessio
INSERT INTO ADDRESS values( 1,'D'Alessio', 'Maria')
SQLSTATMENT is
STATEMENT = "INSERT INTO ADDRESS" values(",
"'"id"',",
"'"vname"',",
"'"lname"')")"
and receive following error
SQL0010N Error "')' .... SQLSTATE 42603
because of literal D' Alessio
Thanks for help
