Inserting values that have single quotes

From: Don Pendergast III <pendergd_at_ohiou.edu>
Date: Wed, 24 Mar 1999 13:49:45 GMT
Message-ID: <36F8ED79.51502563@ohiou.edu>

Hi There!

A single quote is the only way to delimit character string constants. Therefore, other than having two single quotes within the character string in order to represent one single quote is there any other way to enter items into the database that have a single quote in the text (in SQL)?

For example, in order to input a last name of O'CONNOR into a table you would have to have:
INSERT INTO TABLE1 VALUES ('O''CONNOR') is there any other way to put this value into the database without having to add the extra single quote in the name?

Any help at all is much appreciated!

Don Pendergast
pendergd_at_ohiou.edu

Web Analyst/Programmer
Ohio University Received on Wed Mar 24 1999 - 07:49:45 CST