Milt,

in ANSI SQL - I am not sure if it is exactly the same in the VFP implementation of SQL - the COUNT() statement applies to the rows and the columns of the SQL result while your expression inside the COUNT parenthesis is targeted towards the SQL source 'subscriber'. Maybe you would rather put this expression in the WHERE clause of the SQL statement and count the resulting rows:

SELECT COUNT(*) ;
    ... ;
    WHERE EMPTY(subscriber.c_premiumproduct_id)

Robert Stralka