[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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