PDA

View Full Version : how to preform search for decimal values greater than .00 - MSSQL


bhakti_thakkar
07-28-2008, 08:17 AM
hi all,
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

shyam
07-28-2008, 07:04 PM
select * from table where (col - truncate(col, 0)) > 0;