On Wed, 17 Jun 1998 [EMAIL PROTECTED] 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
[EMAIL PROTECTED]                      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


Reply via email to