Re: Special Characters in a string

[John Milardovic <milardj@SX.COM>]

I tried basically the same code and didn't have any problem.

        begin-sql
        update tableX
        set columnY = 'Res & Dev'
        where columnZ = 100;
        commit;
        end-sql

My table was updated correctly using Oracle 8 and SQR 4.

John Milardovic
> -----Original Message-----
> From: Rosie ODonnell [SMTP:joe.patton@NA.MARCONICOMMS.COM]
> Sent: Tuesday, July 06, 1999 2:32 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Special Characters in a string
>
> Hi,
>
> Hopefully, this is an easy one.  Here is an example:
>
> update ps_dept_tble
> set descr = 'Research & Development'
> where deptid like '1847%'
>
> The ampersand(&) is looked at as a replacement variable.  What do I need
> to
> surround it with so that the program ignores the ampersand and considers
> it part
> of the string?
>
> Thanks,
>
> Joe Patton
> Marconi Communications