I have a column named nRUN_TIME that is a smallint. the numbers in this colum are minutes a product ran. so on an average it is anywhere between 84 and 130 minutes. I need to divide this number by 1440 to give me the fraction of a day. for example, I have one record at 136 minutes and I need the results to be 0.094 after I divide it by 1440. If I do this in SQL the number comes out to 0. I tried to convert nRUN_TIME to a decimal and a numeric, but it either gives me errors or I still get a 0. What can I do in this situation?