Forums before death by AOL, social media and spammers... "We can't have nice things"
| comp.databases.paradox | To crash or not to crash, asks Borland | 9,834 messages |
[ << oldest | < older | list | newer > | newest >> ]
| Message 9,605 of 9,834 |
| Larry DiGiovanni to a13965@gmail.com |
| Re: How to put Single Quote and Double Q |
| 29 Jan 09 18:37:56 |
d82272d1
From: nospam@nospam
wrote:
> 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
--- SoupGate-Win32 v1.05
* Origin: you cannot sedate... all the things you hate (1:229/2)
|
[ << oldest | < older | list | newer > | newest >> ]
(c) 1994, bbs@darkrealms.ca
