You are right.  It worked perfectly.

At 10:19 AM 10/12/2000 -0600, Dave Darnell wrote:
>Although I'm not familiar with the SQL syntax standards to be sure, I have
>for many years relied on other systems, software, and languages to interpret
>two delimiter characters together as an "escaped" single literal character.
>You could test this by entering into your present version of the user
>program the string (without my double quotes) "this doesn''t work"
>
> > -----Original Message-----
> > From: Tom Brandt [mailto:[log in to unmask]]
> > Sent: Thursday, October 12, 2000 9:59 AM
> > To: Dave Darnell; [log in to unmask]
> > Subject: Re: SQL INSERT statement syntax
> >
> >
> > I am not sure how that would solve the problem.  Would not
> > the first single
> > quote it saw look like the end of the string - even though it is not?
> >
> > At 10:09 AM 10/12/2000 -0600, Dave Darnell wrote:
> > >I'm not sure about using other delimiters, but would it not
> > work ti parse
> > >the input string for the single quote and change it to two
> > single quotes?
> > >
> > > > -----Original Message-----
> > > > From: Tom Brandt [mailto:[log in to unmask]]
> > > > Sent: Thursday, October 12, 2000 9:48 AM
> > > > To: [log in to unmask]
> > > > Subject: SQL INSERT statement syntax
> > > >
> > > >
> > > > I am using SQL to insert a row into a table, with the
> > > > following syntax:
> > > >
> > > > INSERT INTO Survey VALUES ('<val1>', '<val2>',
> > '<val3>',...'<valn>')
> > > >
> > > > I am using a single quote (') to delimit text strings.   The
> > > > problem is
> > > > that if a user types a single quote into one of the fields,
> > > > the result is
> > > > something like 'This does'nt work'.  The single quote
> > looks the ending
> > > > delimiter of the string, and confuses SQL.
> > > >
> > > > Can I use other delimiters besides single or double quotes to
> > > > delimit text
> > > > strings?
> > > >
> >