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

Re: Special Characters in a string

Joe,

How about taking the easy way out? Replace the & with AND. :-)  Special
charcaters are a pain in the butt.

clark


----Original Message Follows----

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


_______________________________________________________________
Get Free Email and Do More On The Web. Visit http://www.msn.com