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 LazyDBA home page