Re: How to use SQL to update a substring?

[Tony Carolla <carolla@xxxxxxxxx>]

Well, although probably not RPG related, use the functions in SQL to
accomplish this:

Update FileXXX
Set Field1=Left(Field1,5) || '2' || Right(Field1, Length(Field1)-6);

It kinda spoils me in RPG to either use a DS, or just use the %SUBST BIF.  


On Wed, 16 Mar 2005 10:55:47 -0500, Gottlieb, Mike
<MGottlieb@xxxxxxxxxxxxxx> wrote:
> I can't seem to use SQL to update a SUBSTR of a field.
> 
> I'm trying to do:
> 
> UPDATE FILEXXX SET SUBSTR(FIELD1,6,1) = '2'
> SQL won't let me do it.
> 
> Are there any workarounds for this ?
> 
> TIA,
> Mike
> 
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> 
> 


-- 
"Enter any 11-digit prime number to continue..."