Re: [GENERAL] Problem with apostrophe

On Wed, 17 Jun 1998 eric@gateway.ctlno.com 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.

--
Amos Hayes					  Systems Architect
ahayes@ingenia.com			Ingenia Group - Software Kinetics Ltd.
http://smurf.ingenia.com/~ahayes		http://www.ingenia.com

"Remember: No one can make you feel inferior without your consent."
   - ELEANOR ROOSEVELT