Re: Changing Specific Words with the UPDATE statement

Try looking at the replace function, you can use it in the update statement.

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/function.htm#84654

hassan_ayub_at_yahoo.com (Hassan Ayub) wrote in message news:<1df2b71.0111080754.731d5e69_at_posting.google.com>...
> Hi there,
> Is there any possibility that one can use the UPDATE statement in
> such a manner that only one specific word is changed in a column/field
> and the rest of the words/characters in the column/field remains the
> same. For example:
>
> Cylinders Empty for Nitrogen Gas
>
> Now I want to change Cylinders to Cylinder and the rest of the
> statement should remain the same, but whenever I run the UPDATE
> statement it changes the whole statement to Cylinder only. Do I need
> write a procedure or something for this purpose?
>
> Thanks in advance
>
> Hassan
Received on Thu Nov 08 2001 - 20:39:10 CET