Hi Tore

>Where .T.

Thanks for your quick reply. I already have a WHERE clause as below:

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

How do I fit in the .T.. From the top of my head if I do an OR .T. the view will always return all records.

UPDATE: This is from a remote view thus the COALESCE else it would have been EVL