just use
'Research '& Development'
use that extra single quote (') before &.
Pankaj
-----Original Message-----
From: Rosie ODonnell [mailto:joe.patton@NA.MARCONICOMMS.COM]
Sent: Tuesday, July 06, 1999 11:32 AM
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