Can we update a part of string using SQL query?

p.bhaskar naidu · New User Joined: 25 Jun 2005 Posts: 11

Hi,
i want to update a part of string for a column in a table.

Can we update using SUBSTR function or do we have any other ways of doing it???

Regards
Bhaskar

Phrzby Phil · Posted: Fri Jan 25, 2008 7:14 pm

Try substr with concatenation and let us know.

rag swain · Posted: Fri Jan 25, 2008 8:53 pm

Some other functions you could think of using are STRIP, LEFT, RIGHT etc. might be helpful based on your detailed requirement.

rashmi.ranjan75 · New User Joined: 20 Feb 2006 Posts: 34

you can try TRANSLTAE or REPLACE function if suited for your requirement.

Phrzby Phil · Posted: Fri Feb 22, 2008 9:33 pm

Alas - our op is out.