I'm placing this question in this forum either, as I'm not sure if MS SQL forum is right forum for this.

Hello I need help ,

I have this formula

select ((m * power(2,7) + n) | 0x80000000) , where n,m are positive numbers,

in any case the result is different in both servers ,

for example if n=5,m=1 the result

in MS SQL 2000 is -2147483007 (negative number ),

but in My SQL 5 is 2147484289 (positive number ), but in my application I need negative number in result.

How can I adjust this formula in order to get the same result like in SQL Server ?

Can anyone help me to solve this issue ? Please help to solve this.

Any help is appreciated.

Thanks in advance.
Edit/Delete Message