Problem using POWER function with a negative exponent

Question

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Mike_D Hall of Fame Points: 3295 More actions · Answer 1

I think you will find that the result is the same type as the numeric expression so 2 is type int therefore you get zero. Try something like:

SELECT POWER(CONVERT(float,2),-3)

Hope that helps,

Mike

sygerb77 SSC-Addicted Points: 414 More actions · Answer 2

SSC-Addicted

Points: 414

August 25, 2009 at 9:44 am

Awesome. Thanks so much Mike!

Cookies on SQLServerCentral