Naveen J V - Monday, October 23, 2017 12:03 AM

Hello Experts,

I have a data in a table as shown in the first column (A) and would like to update as shown in column B.

Please note there is a space on both sides of the operator (+, -, /, *).

Only these four arithmetic operators would be used. Except, operators and numerals, other words should be enclosed by [ ].

Please do help me to achieve this either using query or using user defined function or stored procedure.

A	B
Total Deduction  *  10	[Total Deduction]  *  10
Remium  +  0.01	[Remium]  +  0.01
100 / Final Results	100 / [Final Results]
Pre Results + 10 - New Results	[Pre Results] + 10 - [New Results]

Thanks,

Naveen J V