On Wed, 17 Jun 1998 eric(at)gateway(dot)ctlno(dot)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(at)ingenia(dot)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