Nope,

select substr(colname,3) from table

vittal
----- Original Message -----
From: "Nandeesha S" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Friday, January 31, 2003 12:48 PM
Subject: RE: Update records


> Hi : I think this will work..
>
> SQL> select substr('TP2390349',1,2) from dual;
>
> SU
> --
> TP
>
> SQL> select replace('TP2390349','TP','00') from dual;
>
> REPLACE('
> ---------
> 002390349
>
> SQL> update table a set column1=replace(column,'TP','00')
> 2 where column1 like 'TP%'
>
> Best Regards
> Nandeesha S
> Mascot Systems Ltd
> Ph : 91-80-552 1701/1706 ( Extn : 4126)
> Fax : 91-80-552 1704
>
> > -----Original Message-----
> > From: [Email Address Removed] [SMTP:[Email Address Removed] > Sent: Friday, January 31, 2003 12:40 PM
> > To: LazyDBA.com Discussion
> > Subject: Update records
> >
> > 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 documentation is here:
> > http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > To unsubscribe: send a blank email to oracledba-[Email Address Removed] > To subscribe: send a blank email to oracledba-[Email Address Removed] > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> > Tell yer mates about http://www.farAwayJobs.com
> > By using this list you agree to these
> > terms:http://www.lazydba.com/legal.html
> >
> >
> DISCLAIMER: Information contained and transmitted by this E-MAIL is
> proprietary to Mascot Systems Limited and is intended for use only by the
> individual or entity to which it is addressed, and may contain information
> that is privileged, confidential or exempt from disclosure under
applicable
> law. If this is a forwarded message, the content of this E-MAIL may not
have
> been sent with the authority of the Company. If you are not the intended
> recipient, an agent of the intended recipient or a person responsible for
> delivering the information to the named recipient, you are notified that
any
> use, distribution, transmission, printing, copying or dissemination of
this
> information in any way or in any manner is strictly prohibited. If you
have
> received this communication in error, please delete this mail & notify us
> immediately at [Email Address Removed] Before opening attachments,
> please scan for viruses.
>
>
>
> --------
> Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html

DISCLAIMER
---------------------------------------------------------------------------
This email message and any attachments is confidential and intended only for
the use of an individual or entity named above and may contain information
that is privileged, confidential or exempt from disclosure under applicable
law. If you are not the intended recipient, you are notified that any
dissemination, distribution or copying of this email is strictly prohibited.
If you have received this email in error, please notify us immediately by
return email or [Email Address Removed] and destroy the original message.
Opinions, conclusions, and other information in this message that do not
relate to the official business of SPAN, shall be understood to be neither
given nor endorsed by SPAN
________________________________________
Mails are Scanned and Filtered for Virus
[Email Address Removed]Oracle LazyDBA home page