At 01:10 PM 08-12-01 +0000, you wrote:

>Thanks for the reply, I didn't knew about the EXISTS function and
>that I was looking for. So the Exists funtion returns True when the
>select statement returns 1 or more rows?

Not exactly. EXISTS() is a test that determines whether the proposed SELECT would return a dataset. It returns only True or False - making it very low-cost.

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________