Some_Id is integer in all tables tested.

select * from tableA a ;
  inner join TableB b on a.Some_Id=b.Some_Id ;
  where b.Some_Id between 1 and 0xFFFFFFFF

Returns 0 records !!! but :

select * from tableA a ;
  inner join TableB b on a.Some_Id=b.Some_Id ;
  where a.Some_Id between 1 and 0xFFFFFFFF

Returns n records. This is a problem if you have more joins and have to use a field from any table except first. If you use 0x7FFFFFFF then it works. It doesn't help if you write in hex notation or not. I really could have a value greater than (should I say less than) 0x7FFFFFFF. Any reference to this on MSDN ? TIA.
PS: I'm aware that an integer is in the range –2147483647,2147483646. I just can't understand why it works partially.
Cetin