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?
>