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

From: Kevin Lange <kgel_at_ppoone.com>
Date: Mon, 23 Jul 2001 13:26:00 -0700
Message-ID: <F001.003528C9.20010723133323@fatcity.com>

A
really ugly way is always to do the
<FONT face=Arial color=#0000ff

size=2>
<FONT face=Arial
color=#0000ff size=2>Insert into table MyData values (first_value, second_value, 'A&'||'M University');
<FONT face=Arial color=#0000ff

size=2>
Its
worked in SQLPlus doing that by hand ..... but its ugly. Gotta be a beter way.

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Helen rwulfjeq   [mailto:lannyue_at_yahoo.com]Sent: Monday, July 23, 2001 12:51   PMTo: Multiple recipients of list ORACLE-LSubject: How   to deal with special character like & in ' '   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<A
href="http://phonecard.yahoo.com/?.refer=mailtagline">http://phonecard.yahoo.com/ Received on Mon Jul 23 2001 - 15:26:00 CDT