----- Original Message -----
From: "Colin Taylor" <Colin_Taylor(at)PortaSystemsDev(dot)com>
> Hi,
> I have been having a few problems with strings (varchar)s.
> How can I insert a quote ' character in a string?
> The following, needless to say does not work:
>
> INSERT INTO table (string) VALUES ('colin's');
>
INSERT INTO table VALUES ('colin\'s back\\slash');
The doubled-backslash is used to put a backslash in. Perl, PHP and the like
provide help with this sort of thing.
- Richard