Hi James !

I am not certain, but you might add parenthesis in your sql select

select dam1, yr_bred, name, sex, sire1, booked_to, last_bred, p_b, date_foal,;
date_died, cause_deat,price_sold, buy_name, age_rec, life_earn, cl;
from master;
where category = "F" and ;
(type = "S" or type = "W" or type = "Y")
order by dam1;
into table foals nofilter

- You can change the line (type = "S" or type = "W" or type = "Y") by
a) inlist(type,"S","W,"Y")
b) type $ "SWY"

Stef