Hi John

Was this post updated, cause I saw differently when I replied to you just before, or maybe it is time for my meds :)

Thanks I guess this is what I was meaning when I last replied to your post.

>assuming IID is an autoincrementing key or similar, how about adding something along the lines of
>
>

WHERE COALESCE(TPACKINGLIST.IPKLNO, 0) != 0 ;
>  OR TPACKINGLIST.IID = ?VP_IID
>  OR TPACKINGLIST.IID < ?VP_FULL

>
>Then you can set VP_FULL to -1 for a normal query, or to some enormous value when you want all records.