How to put Single Quote and Double Quote in one SQL Statement at theSame time

#1

Hi, I have a table t, which has only one alphabat field, then I want
to add this record: A'B"

But how can I do this in a dynamic SQL? I tried:
INSERT INTO t VALUES('A'B"')
failed
INSERT INTO t VALUES("A'B"")
failed

Your help is appriciated!

#2

<a13965 (AT) gmail (DOT) com> wrote:

Quote:

But how can I do this in a dynamic SQL? I tried:
INSERT INTO t VALUES('A'B"')
failed
INSERT INTO t VALUES("A'B"")
failed

Your help is appriciated!

I believe you must escape the " with a backslash (\) and double up on the ',
as in:

INSERT INTO t VALUES('A''B\"')

--
Larry DiGiovanni

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to put Single Quote and Double Quote in one SQL Statement at theSame time

comp.databases.paradox comp.databases.paradox

How to put Single Quote and Double Quote in one SQL Statement at theSame time - 01-29-2009 , 10:46 AM

Re: How to put Single Quote and Double Quote in one SQL Statement at the Same time - 01-29-2009 , 05:37 PM