Sublime Forum

Challenging String Manipulation in TSQL

#1

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.

Thanks,
Naveen

0 Likes

#2

You’re posting in the wrong forum. Try a TSQL or SQL forum.

0 Likes