Re: SQL Statement error

Syed Rashid wrote:
>
> 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

SQL> set scan off Received on Wed Jun 04 1997 - 00:00:00 CDT