Thank you Ivan,

Just what I want.

> If you have FB1.5:
>
> select saleprice + 0 , count(saleprice)
> from presence
> where productID = 1959201 and valuedate = '2004-04-01'
> group by 1
> order by 1
>
> Ivan
>