>I'v looked at the table, and all the value are numeric, either
>0.00 or greater. But no nulls

Eventhough, columns don't have null values, your SQL statement columns can have null values depending on the type of SQL. For example, if you are doing an OUTER JOIN, columns will have NULL values for the table on the right hand side in the WHERE clause, if the match is not found.