InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 13:29:20 GMT20http://www.sqlservercentral.com/Forums/Topic911625-153-1.aspxStill not sure what the problem is... your example works just fine:[code="sql"]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*/[/code]Thu, 29 Apr 2010 09:22:41 GMTLutzMhttp://www.sqlservercentral.com/Forums/Topic911625-153-1.aspxHi,Create table ab(date datetime,amount decimal(10,2),interest float,)data:2009-04-10 00:00:00.000 450.00 00.232009-04-10 00:00:00.000 451.00 -1.202009-04-10 00:00:00.000 460.00 2.5select date, amount, interest from ab where interest > 0 Output:Its showing the all the record. but i need only two records.also i tried below query, but notselect date, amount, interest from abwhere case sign(amount) when -1 then 1 else 0 end = 0Thanks...Wed, 28 Apr 2010 21:52:48 GMTstanley 86917http://www.sqlservercentral.com/Forums/Topic911625-153-1.aspxHere's a sample code that works as expected:[code="sql"]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*/[/code]What values would I need to insert to describe the scenario you're faced with?Wed, 28 Apr 2010 12:23:10 GMTLutzMhttp://www.sqlservercentral.com/Forums/Topic911625-153-1.aspxHi,Na. I tried and it wont work. It will bring the negative values too.i checked with case and its working in select clause but not in where clause. thats the problem Wed, 28 Apr 2010 04:28:09 GMTstanley 86917http://www.sqlservercentral.com/Forums/Topic911625-153-1.aspxMaybe something like this?[code="sql"]WHERE float_column > = 0.0 [/code]Wed, 28 Apr 2010 03:43:12 GMTLutzMhttp://www.sqlservercentral.com/Forums/Topic911625-153-1.aspxhow to filter the negative value from the float columnTue, 27 Apr 2010 23:25:30 GMTstanley 86917