Home » SQL & PL/SQL » SQL & PL/SQL » how can i update by replacing string
icon8.gif  how can i update by replacing string [message #321732] Wed, 21 May 2008 03:14 Go to next message
ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh
Member

Dear friend..
we have lots of row's in my item table with like this data
------------------
CI SHEET .160mm CGL ( 26.0" X .11 X 06')
CI SHEET .190mm CGL ( 26.0" X .113 X 10')
CI SHEET .170mm CGL ( 26.0" X .133 X 12')
CI SHEET .150mm CGL ( 26.0" X .11 X 06')
CI SHEET .110mm CGL ( 26.0" X .143 X 10')
CI SHEET .100mm CGL ( 26.0" X .140 X 12')
--------------
i need just change CGL to NOF,
pls give me how it possible........................
Re: how can i update by replacing string [message #321733 is a reply to message #321732] Wed, 21 May 2008 03:21 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member

Use the replace function in the update statement.
Re: how can i update by replacing string [message #321735 is a reply to message #321732] Wed, 21 May 2008 03:33 Go to previous message
ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh
Member

Thanks........
"ThomasG" for your Nice HElp....
Previous Topic: meaning
Next Topic: Group by with nested sql
Goto Forum:
  


Current Time: Thu Dec 08 22:23:15 CST 2016

Total time taken to generate the page: 0.08413 seconds