I have a sql statement that I am runing against an Informix table. It is a simple query and my question is this.
If there are value to return, then it returns the count of them. However, if there are no values, then it is blank. Is there a way that the count return a Zero if the result is nothing?
Here is my statement:
SELECT informix.sfu_inventory_rec.brand, Count(informix.sfu_inventory_rec.invid) As Count_invid
WHERE informix.sfu_inventory_rec.brand = 84
Group By informix.sfu_inventory_rec.brand