Reference Guide > Function Support for Data Sources > Function Support Issues when Combining Data Sources > Decimal Digit Limitation on Functions
 
Decimal Digit Limitation on Functions
In TDV version 7.0.2 or later, add, subtract, multiply, divide, and modulo operators in functions follow SQL Server's behavior, which prevents precision/scale from exceeding 38 digits. But customers might need to wrap CASTs around columns in cached tables whose data types no longer match in such situations, so a configuration parameter has been made available to restore pre-7.0.2 behavior.
The name of the boolean configuration parameter is Decimal digit limitation in functions:
When set to True (the default), add, subtract, multiply, divide, and modulo operators in functions prevent precision/scale from exceeding 38 digits.
When set to False, add, subtract, multiply, divide, and modulo operators in functions allow precision/scale to exceeding 38 digits.