converting decimal values to smaller decimal values

[ketanshah123]

Hi

How can I convert decimal values of say length 7,2 to length 5,2 ?

Thanks in advance

[chulett]

You could probably do an implicit conversion, or explicitly using the DecimalToDecimal() function. Keep in mind the fact that you are going to get warnings whenever you do something like this, sending a larger something to a smaller something as it won't necessarily fit.