SQL Statement error

Can anyone tell me what do I have to do to make the following update statement to accept the "&" symbol in the first place. Is there anyway to automate this, so any sql statment will accept "&" in any field?

SQL> update contact set cncompany = 'AB&D' where cncompid = 'cp9208'   2 ;
Enter value for t: &D
old 1: update contact set cncompany = 'AB&D' where cncompid = 'cp9208 new 1: update contact set cncompany = 'AB&D' where cncompid = 'cp9208

1 row updated.

Thanks much
Syed Rashid Received on Tue Jun 03 1997 - 00:00:00 CDT