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?