Use the POWER function to raise one number to the power of another number. The first argument is the base value. The second argument is the exponent to which to raise the base number.

If the first argument is a decimal, Compass casts the value to decimal(38,15) before it is raised. This may result in different results than SQL Server: In SQL Server, the value is cast to the nearest decimal value for the scale and precision of the argument.

If the result of the POWER function is too large to be cast, an error is returned.


POWER(base_number, exponent_number)