DM> SELECT COUNT(*), AVG(income) FROM tbl WHERE ...

DM> then you'd get one row, but two columns - column 1 is the 
DM> count, and column 2 is the average of the income column in 
DM> the tbl table, both using only the subset that matches the 
DM> WHERE condition.

I like it.  However, COUNT(*) is not one of my own variables and there 
is no documentation in Watcom that tells me exactly what is returned:  
long, word or byte.  However, a little experimenting shouldn't be very 
difficult and should tell me exactly what I need to know.  Thanks for 
the idea.


DM>> SQLINTEGER count;
DM>> if (retcode == SQL_SUCCESS || retcode ==
DM>> SQL_SUCCESS_WITH_DATA) {
DM>>   SQLINTEGER cb;
DM>>   SQLGetData(bstmt, &count, 0, &cb);

Upon re-reading this, I'll have to try it.

þ CMPQwk 1.42 999

--- Maximus/2 3.01