Re: Where clause containing Ampersand

set scan off
update table
 set field = 'New Text'
 where field = 'Jay & Silent Bob';
set scan on

Christophe.

"James Alexander Starritt" <james_at_jamesstarritt.com> a écrit dans le message news: 9vnle1$gi8pf$1_at_ID-68406.news.dfncis.de...
> I have a where clause that contains an & as part of it. Oracle prompts
for
> a value, assuming that this is a variable. How do I put a literal
ampersand
> in my where clause.
>
> update table
> set field = 'New Text'
> where field = 'Jay & Silent Bob';
>
> Any ideas. Should be easy as pie but I can't figure it out
>
> --
>
> James Starritt
>
>
Received on Tue Dec 18 2001 - 09:53:06 CST