Re: Special Characters in a string

["Wendel, Robbi" <rwendel@NESPOWER.COM>]

You might try two single quotes --  ''&''

Robbi

-----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