--- In firebird-support@yahoogroups.com, "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