I have the following values returned in a column. 0.250000 and 13.000000. I would like to bypass 0.250000 to 1 and leave 13 as it is. Any easy way to do this since they both end up in the same column?
Your DBMS probably has a CEILING function. Try it.
The ceiling function will work well because you want to round to the nearest whole number. More rounding methods with SQL Server ....
SQL Server rounding methods
select CEILING (column name) from tablename