>Hi
>
>>What I do is something like this :
>>
>>m.lnMin = iif(empty(m.tnID),0,m.tnID)
>>m.lnMax = iif(empty(m.tnID),0x7FFFFFFF,m.tnID)
>>
>>and query looks like :
>>.... myID between ?m.lnMin and ?m.lnMax
>
>Thanks a lot.
>
>Just curious, I am not a Hex guy, how would you represent the same no above as negative in Hex, just a minus sign?
Yes. In signed integer for negative values the uppermost bit is set : So it'd be :
-(0x7FFFFFFF+1)
or:
-0x80000000
Cetin