Re: Inserting values containing single quotes...

From: Damond Walker <dwalker_at_iximd.com>
Date: Sun, 27 Jun 1999 13:03:15 GMT
Message-ID: <nipd3.468$uo3.19825@typhoon1.gnilink.net>

Try using two single quotes... example...

insert into <sometable>(Description) values('Howard''s bogus place...');

Easier to type than that whole ... & chr(34) & ... mess (or whatever character you hope to embed in a SQL string). As a side benefit, the two single quotes work with just about everything you can hit from VB.

Damond

Dave Carr > wrote in message <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 Sun Jun 27 1999 - 08:03:15 CDT