Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Modify the first char
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