WHERE float_column > = 0.0
DECLARE @tbl TABLE ( float_column FLOAT )INSERT INTO @tblSELECT 0 UNION ALLSELECT 0.001 UNION ALLSELECT -0.001 UNION ALLSELECT -1110 SELECT *FROM @tblWHERE float_column > = 0.0 /* result setfloat_column00,001*/
DECLARE @tbl TABLE( DATE DATETIME, amount DECIMAL(10,2), interest FLOAT)INSERT INTO @tblSELECT '2009-04-10 00:00:00.000', 450.00, 00.23 UNION ALLSELECT '2009-04-10 00:00:00.000', 451.00, -1.20 UNION ALLSELECT '2009-04-10 00:00:00.000', 460.00, 2.5SELECT DATE, amount, interest FROM @tbl WHERE interest > 0 /* result setdate amount interest2009-04-10 00:00:00.000 450.00 0,232009-04-10 00:00:00.000 460.00 2,5*/