Re: Special Characters in a string

[John Milardovic <milardj@SX.COM>]

Hi Rosie.
        To escape a character just repeat it.   && '' ## etc.

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