SQL is all about sets.
In this situation where there is nothing to group the original values
together and nothing to describe the update you would have to use separate
updates for each line.
In your original example a rule could be created for the update, this is not
the case with this example.
The only way to get round this would be to create a "translation" table, in
this table you would define the original value and the target value you
could then use this to update your table. This really is only any use where
the values appear multiple times and would certainly not be suitable in a
case as trivial as the one you cite.
--
Terry Kreft
"equalive" <eq******@yahoo.com> wrote in message
news:11*********************@j73g2000cwa.googlegro ups.com...
Yes, its working fine with your coding, Thanks.
But how if it is not an alphabet or a word such as
Mouse -> Snake
Snake -> Eagle
Deer -> Tiger
Earlier i juzt use Alphabatical so that easy for the reader to
understand. Can you guide me on above situation if it is a word rather
than alphabet. Thanks again.