Re: Modify the first char

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Fri, 9 Jun 2006 16:05:35 -0400
Message-ID: <naqdnTXNVowOSRTZnZ2dnUVZ_tmdnZ2d@comcast.com>

"null" <null_at_null.it> wrote in message
news:4489cfc1$0$18292$4fafbaef_at_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

substr() function and concatenation operator

make sure you download a copy of the SQL Reference manual from http://tahiti.oracle.com and get familiar with Oracle's built-in functions

++ mcs Received on Fri Jun 09 2006 - 15:05:35 CDT