I need help formatting numbers in a specific way.
If a number has 3 digits or less, I would like it to remain the same.
If a number has more than three digits, I would like it place a decimal after the third decimal.
123 --> Stays the same 1234 --> 123.4 1234567 --> 123.4567
I am using SQL Server and want to
UPDATE the value in the table. The value is stored as a numeric.