Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Modify the first char

Modify the first char

From: null <null_at_null.it>
Date: Fri, 9 Jun 2006 19:44:46 GMT
Message-ID: <4489cfc1$0$18292$4fafbaef@reader1.news.tin.it>


Hi! I've a query

INSERT fields...
SELECT fields

in the select I've a field with this format

XX05

How Can I modify the first 2 char with 20 for have 2005 ????

In the select I want to modify all the first 2 char in '20' of this field

Thanks Received on Fri Jun 09 2006 - 14:44:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US