CharlieBrowne 
6540 pts. | Oct 1 2009 12:53PM GMT
Thanks Phil
Worked perfert.
I had tried REPLACE but had the wrong syntax.
Q:
Using AS400 SQL to replace a variable string
I need to do a scan and replace in a flat file. File has one field 80 characters long. Possibly one or more of the records in the file contain a specific value, such as '%ABC%' and I want to update the record replace ABC with XYZ. This value could be anywhere within the record. I do not want to take the time to do an RPG program. Prefer to use RUNSQLSTM. Any ideas?
Software/Hardware used:
AS400 V5R4
Software/Hardware used:
AS400 V5R4
ASKED:
Sep 30 2009 7:01 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
update Myfile set MyField = replace(Myfield,'ABC','XYZ')
but use care - this will replace every ABC with XYZ
even the second or third occurance on the same record.
I recommend that you view the data first
Select Myfield from MyFile
where MyField like ('%ABC%')
Phil
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
