I think you need to use the escape option:
WHERE last_name LIKE '%A\_B%' ESCAPE '\';
Try 'UVWX\&Z ESCAPE \'

Randy Patterson
> [Email Address Removed] Anadarko Petroleum Corp.
P.O. Box 1330
Houston, TX 77251-1330
(832)636-1655




> -----Original Message-----
> From: [Email Address Removed] [SMTP:[Email Address Removed] Sent: Monday, June 30, 2003 2:30 PM
> To: LazyDBA.com Discussion
> Subject: Re: Another Question
>
> i think you need to do this
>
> 'UVWX''&''Z'
>
> try that. its going to be something with the quotes. Ive found keeping
> track of quoting to be tedious.
> >
> > From: "Bill Ducker" <bill.[Email Address Removed] > Date: 2003/06/30 Mon PM 03:27:45 EDT
> > To: "LazyDBA.com Discussion" <[Email Address Removed] > Subject: Another Question
> >
> > update TABLE_NAME set column_name = 'ABCDEFG'
> > where column_name = 'UVWX&Z';
> >
> > This looks like it should be easy, BUT... it interprets the
> ampersand ('&') in the string literal as some sort of variable, stops,
> and issues this statement:
> >
> > Enter value for Z:
> >
> > How to I get around this problem?
> >
> >
> >
> >
> > --------
> > Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] > To subscribe: send a blank email to
> oracledba-[Email Address Removed] > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> > Tell yer mates about http://www.farAwayJobs.com
> > By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
> >
> >
>
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html


Anadarko Confidentiality Notice:
This electronic transmission and any attached documents or other writings
are intended only for the person or entity to which it is addressed and may
contain information that is privileged, confidential or otherwise protected
from disclosure. If you have received this communication in error, please
immediately notify sender by return e-mail and destroy the communication.
Any disclosure, copying, distribution or the taking of any action concerning
the contents of this communication or any attachments by anyone other
than the named recipient is strictly prohibited.

Oracle LazyDBA home page