Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
07-28-2008, 08:17 AM #1
- Join Date
- Sep 2006
- India Mumbai
- Thanked 1 Time in 1 Post
how to preform search for decimal values greater than .00 - MSSQL
i am having a table in which i have a column datatype (decimal) .
Now i want to find all the rows where value in that column is greater than .00 eg if there are 3 rows with values : 50.50 , 11.1 , 12 , 14.01 then query should return me only 50.50 , 11.1 and 14.01.
Thnaks in advance
07-28-2008, 07:04 PM #2
Code:select * from table where (col - truncate(col, 0)) > 0;
You never have to change anything you got up in the middle of the night to write. -- Saul Bellow