Re: Inserting values containing single quotes...

You can embed double quotes around your string by puting Chr$(34) around the values in the string you build, which will cause ADO tyo interpret the single quote as part of the value. A stored procedure is usually a better way to do it, but if that's not an option try this. If you are literally trying to insert a single quote into your string, you can use the Chr$() function also, using the ascii code you the single quote, but you're still going to need the double-quote delimiters.

--

Aaron Boldt
Computer Solution Specialists, Inc.
boldt_at_mediaone.net
Dave Carr <david_carr_at_cargill .com> wrote in message news:01bec009$2d93eb60$9415010a_at_fdcmes01wp...
> How (within VB6/ADO) do you insert or update columns with data that
> contains
> single quotes?
>
> I thought I just add a single quote whenever one is found in a string...
> which works
> in the SQL window but not in code...
>
> TIA,
> -Dave
> dcarr<at>gr<dot>com
Received on Sat Jun 26 1999 - 15:54:59 CDT