RE: How to deal with special character like & in ' '

[Kevin Lange]

Thanks Joe.   I did not know that command existed.    Makes life easier. -----Original Message----- From: JOE TESTA [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 1:49 PM To: Multiple recipients of list ORACLE-L Subject: Re: How to deal with special character like & in ' ' set scan off   joe >>> [EMAIL PROTECTED] 07/23/01 01:51PM >>> Hi, I want to insert a string like 'A&M University' but has problem with '&'   I want the database exact A&M University. But it always ask me new or old value because of symbol '&' how could I deal with that. Thanks. HL Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/