>SELECT YourTableAlias >COUNT TO lnLive FOR NOT DELETED() >The nice thing about this is that it works regardless of set("deleted"). The contrary is funny, though - count for deleted() will return zero if deleted is on, and the actual count when off. Which is something that can confuse any beginner (or an oldster who forgets about how set deleted works).