Hello,

I've been wrestling with this issue
for a long while now so I am hoping
some could give some indication to
what I am doing wrong.

I expected this script to work...

create table testtable ( testcol int  );
insert into testtable ( testcol ) values ( -2146369472
)
select * from testtable where ( testcol & 4294967295 )
= -2146369472

Note that 4294967295 in binary is
all '1's.

Also if -2146369472 is changed to
2146369472, then the select query
works.

Could someone explain my error to
me?

Best regards,
Kervin



-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to