SQL

 
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) 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



===============================================
DESCR1 LOC BRANCH VALUE
A 01FEB 13 AXA INS LHR 4500 91 LON
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