Re: Modify the first char

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 09 Jun 2006 22:08:16 +0200
Message-ID: <a6lj82le9hnc6bp5q4k96gpeq5t1a1i7h1@4ax.com>

On Fri, 9 Jun 2006 19:44:46 GMT, "null" <null_at_null.it> wrote:

>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

Given this is homework, what did you try yourself?

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Jun 09 2006 - 15:08:16 CDT