I think it was Helen who wrote a few days ago that if you have a primary
key, then the best way would be

SELECT MIN(Primary Key) FROM ...

At 08:57 AM 5/6/2003 +0500, you wrote:

>On 5 May 2003 at 15:00, mcrosman1957 wrote:
>
> >I am developing a store procedure and a trigger in which I need to
> >check if a table is empty or not.
>
> IF (EXISTS (Select * from MyTable)) THEN ...
>
> SY, Dimitry Sibiryakov.
>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.476 / Virus Database: 273 - Release Date: 4/24/2003

[Non-text portions of this message have been removed]