Re: Special Characters in a string

[Arshad Pervez <perveza@SX.COM>]

> -----Original Message-----
> From: Julie Waggoner [SMTP:WAGGO000@MAIL.GENMILLS.COM]
> Sent: Tuesday, July 06, 1999 3:07 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Re: Special Characters in a string
>
> You can use the Chr() function which returns a character based on the
> ASCII
> number you provide.  The ampersand is Chr(38).
>
> For instance:
> update ps_dept_tble
> set descr = 'Research ' || Chr(38) || ' Development'
> where deptid like '1847%'
>
> Julie
>
> -----Original Message-----
> From: Rosie ODonnell [mailto:joe.patton@NA.MARCONICOMMS.COM]
> Sent: Tuesday, July 06, 1999 1: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