Using a variable to limit the decimal places
Posted on 2016-10-18
I have a numeric data field (Numeric(18,6)) This is concatenated into a string with some other text values.
Trouble is not all clients want 6 decimal places after the int. I have tried Round() but his retains the 6 decimal places. Converting to a varchar does the job, but how to I make it a variable from probably 2 to 6 in length.
I have a setting table where this value is stored.