Hi,

We have a table in which one varchar field is having some different type of
rows, below is the example of records....

Field A
___________
TP9192383
TP2623833
LLI3289309
LST278238
TP8239834
TP2390349
LLL9012390

Now i need to update this field A , and change the records of those
starting with 'TP%' and change these records to the rest of the values
after 'TP' .
Can some one help me on this.................


Regards....
Shailesh Kumar
Database Administrator


Oracle LazyDBA home page