>Hi Cetin
>
>So we'd have something like this.
>
>m.lnMin = iif(empty(m.tnID),-0x80000000,m.tnID)
>m.lnMax = iif(empty(m.tnID),0x7FFFFFFF,m.tnID)
>
>>>>
>>>>and query looks like :
>>>>.... myID between ?m.lnMin and ?m.lnMax
Yes. Normally I don;t include negative values as my tables do not use negative ID values (actually I tend using GUID ids).
Cetin