On Wed, 17 Jun 1998, Amos Hayes wrote:
> > Is there any way of having an apostrophe in a data field?
> > It is a problem because the apostrophe is the same character as the single
> > quote, so the database gets a parser error when a name such as "O'Brian"
> > is entered.
>
> Have you tried doubling up? 'O''Brian'
>
> That is what I have to do in Oracle anyway.
Isn't there an escape character, like the slash?
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
"The Number of UNIX installations has grown to 10, with more expected."
-- The UNIX Programmer's Manual, 2nd Edition, June, 1972