Comparison statements and NULL values

SQL Server returns an error for a query that contains a comparison statement like 'Value > 0' whenever a NULL is returned. Be sure that you always include 'AND Value IS NOT NULL', so that the NULL values are filtered out.