--- In [email protected], "Arno Brinkman" <fbsupport@...> wrote: > > Hi, > > What about: > > SELECT > tSaleinvoice.* > FROM > tSaleInvoice > WHERE > EXISTS(SELECT * FROM tSaleInvoiceCvrLtr WHERE tSaleInvoice.iID = > tSaleInvoiceCvrLtr.cSaleInvIDs and tSaleInvoiceCvrLtr.iID = :vp_iID) or > (iBuyerID = :iBuyerID AND tSaleInvoice.tDt = :tDt) > > Regards, > Arno Brinkman >
Thanks a lot Arno for the suggestion. But as Mark pointed out my list of comma separated integers stored as a string in cSaleInvIDs won't help me with this. Thanks and regards Bhavbhuti
