Re: Adding a ' in a sql statment
INSERT INTO testtable VALUES ("Rich's Test");
NOTE: Use double quotes to start and end a string.
Don
Richard Krenek wrote:
>
> I am trying to add the line "Rich's test" in a varchar field but I
> cannot add the '. How would I do this? I've tried
> "INSERT INTO testtable VALUES ('Rich\\'s test');" but that does not work.
> Ive even tried \\\\' and \\\\\\'. Any ideas?
>
> thanks,
> Richard Krenek