Something Weird with Sqlplus

[Quoted] I'm running Oracle 8.0.5 on NT4.0.

If I execute a INSERT statement with a alphanumeric field containing an "&" (ie: insert into table1 (field1) values('STONE & COX');), using SQLPLUS, it will respond with "Enter value for cox:".

I know that SQL uses and "&" as a place holder and obviously that's what it is doing here. Here's the weird part! If open the SQL Worksheet in Enterprise Manager and enter the same command it will work.

What is happening? I'm I nuts? Please Help?

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * [Quoted] The fastest and easiest way to search and participate in Usenet - Free!