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!

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 03:12:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.