varchar column, its name is column1 and has records like
1123443530. The last digit is not always
0; it can be
Some of them are digits with (
-), other are digits. I want to change digits to digits with(
1123443530 -> change to ->
if record just be digit just update in column3 else the last digit separate by (-) and then record update in column3
In SQL Server 2012 and put this new record and records with (
-) in new column.
What should I do?