power function Arithmetic overflow error converting expression to data type int. 1

[baran121]

hi ,
when i do query in SQL SERVER down i got an error.

print power(36,6)

Arithmetic overflow error converting expression to data type int.

please help me.

 

[bborissov]

print power(CAST(36 as bigint),6)

Borislav Borissov
VFP9 SP2, SQL Server

 

[baran121]

i found solution thanks.

print POWER(CAST(36 as bigint), 6);

 

[baran121]

thank you bborissov

 

[SkipVought]

baran121, it is appropriate to award a Little Purple Star in such instances, which it appears, over the past decade, you have been loathe to confer (4 out of 120)

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[baran121]

thank you