Problem Inserting "&" sign. (ie. Sampson & Son's)

From: Patrick McCarthy <pmccarth_at_rpc.unb.ca>
Date: 1996/07/04
Message-ID: <4rgr6s$9dh_at_sol.sun.csd.unb.ca>#1/1


I am trying to insert values into a record using Oracle 7.1.4 on Solaris 2.4 Sun workstation. The problem is that I am trying to insert a text value which has the "&" sign in the text array. ie "Maclary & Son's". It keeps coming up with the message insert a value for Son's ?????? It obviously use the "&" to insert a variable field. How can I disable this ????

Thanks
Patrick McCarthy
pmccarth_at_rpc.unb.ca Received on Thu Jul 04 1996 - 00:00:00 CEST

Original text of this message