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?