Home » SQL & PL/SQL » SQL & PL/SQL » Help with SQL script (replace command)
Help with SQL script (replace command) [message #21103] Fri, 12 July 2002 08:54
Arpit
Messages: 99
Registered: March 2001
Member
Hello,

I need to write a replace script which will do the following in order to update my data.

Replace from 'CP234' to CP 234'

How can do this type of replace by inserting a "single space" in after word "CP"

The data looks like eg:-
CP10234
CP123
CP 3456
CP12
CP 23456

Any help on this would be highly appreciated.

Thanks!
Previous Topic: Can we use sql loader using pl/sql
Next Topic: problems with time field
Goto Forum:
  


Current Time: Wed Oct 23 15:37:33 CDT 2019