S.No, Agent_code , Branch, palmtec_id , min_rec , max_rec , Last_billed
1, 1351 , BG , BG10, BG10000058 , BG10000068, 16-02-2016
I want to subtract 68-58 and store in third column
for ex: 68-58 =10
What I have tried:
I had tried (max_rec - min_rec) but it doesnt subtract varchar columns..is there a way to split the values and subtract ...can anyone help me out..thanks in advance