• Guys think deeper, that question is not "what is 2^31" but "why does this fail"

    Its about data type limitations. The correct answer is not given in the error message

    the floating point answer is i.e. 2.0^31 notice the .00000 on its end.

    It fails because it overflows the default/assumed type of int.

    THINK!THINKTHINK! then think again.

    strive to understand before you strive to be understood!

    Hiding under a desk from SSIS Implemenation Work :crazy: