Re: Insert of 'special' (& CR/LF ') char in SQL INSERT

In article <2m79ev$45h_at_mica.inel.gov>, rs6_at_inel.gov (Robert K Smith) writes:
> I have found that to insert a single ' into a field using INSERT
> the ' needs to be doubled to ''. How do you insert a &? Given
> that my company is EG&G, and my customers don't like seeing EG+G,
> I'd like to know how this is done. I'd expect this is a simple
> thing, maybe already in a FAQ, but I don't see a FAQ here either.
>

set escape \
set escape on

insert into TABLE (field)
value ('EG\&G');

Sonja Kattner
sonja_at_cimu05.att.com Received on Thu Mar 17 1994 - 16:19:58 CET