Re: SQL

Would something like below work?
update masterf
set descr1 = left(descr1, 1) || ' ' ||
substr(descr1, 6, 20) || ' ' ||
substr(digits(value),6,4)


"A Paul" <amandapaul1@xxxxxxxxxxx> wrote in message news:<mailman.14886.1360529917.10847.rpg400-l@xxxxxxxxxxxx>...

My pf(masterf) has descr1 (30 char), value(15 8) field
I would like to change description DESCR1 as shown below .
DESCR1 LOC BRANCH VALUE
ABC 01FEB 13 AXA INS LHRTD 91 LON 45.00000000
ABC 01MAR 13 AXA INS LHRTD 91 LON 41.00000000
ABC 04MAR 13 AXA INS LHRTD 91 LON 42.00000000
BALL 05MAR 13 AXA INS LHRTD 91 LON 43.00000000
BALL 06MAR 13 AXA INS LHRTD 91 LON 44.00000000

====================changed as below===========================
DESCR1 LOC BRANCH VALUE
A 01FEB 13 AXA INS LHR 4500 91 LON 45.00000000
A 01MAR 13 AXA INS LHR 4100 91 LON 41.00000000
A 04MAR 13 AXA INS LHR 4200 91 LON 42.00000000
B 05MAR 13 AXA INS LHR 4300 91 LON 43.00000000
B 06MAR 13 AXA INS LHR 4400 91 LON 44.00000000

I have updated one by one as I am not sure how to apply logic to whole bunch of records(basically two types as below) for which I want to seek your help. I also attached a notepad incase if the format does sit right:).
Thank you and appreciate your help!
If you take first example
UPDATE masterf set descr1 ='A 01FEB 13 AXA INS LHR 4500'
where loc='91' and branch='LON' and VALUE = 45.00000000
where DESCR1 ='ABC 01FEB 13 AXA INS LHRTD'

I removed BC and adjusted space and appended 45.00*100(4500)

UPDATE masterf set descr1 ='B 06MAR 13 AXA INS LHR 4400'
where loc='91' and branch='LON' and VALUE = 44.00000000
where DESCR1 ='BALL 06MAR 13 AXA INS LHRTD'
I removed ALL and adjusted space and appended 44.00*100(4400)
----------