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] -----------------------------------------------------------------------------