Silly Problem - Arithmetic Operators (powers) in User Defined Function 1

[AccessUser22]

Hi,

I'm trying to create a function that raises a number to a power of 2. So like 6 squared is 36. However for some reason when I run it it gives me 4 as an answer. This is the syntax I have for the actual computation

SET @Result = (@Variable ^ 2)

Even when I remove @Variable and replace it with a 6 I'm getting 4 as an answer. Where am I going wrong? I know it's probably something silly. I've been playing around with it for a while now. Thanks in advance.

 

[SQLDenis]

declare @Result int
declare @Variable int
select @Variable = 6
SET @Result = POWER(@Variable , 2)

select @Result

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[AccessUser22]

Thanks. I knew it had to be something simple.

 

[SQLDenis]

No problem, ^ is the bitwise operator

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/