I am selcting a field that shows the number of months. So I am dividing by 12 to get the years, but I get a decimal string that I want to consolidate. So i tried CAST and Round but got whole numbers. Then I also have problem of dividing by zero. So how can i check for zero and show only like example below.
For example If Ithe field has 91 months it comes out as
I would like it to be 7.58
Select Cast(sidstrNBR_MO_ACT_FED_SVC /12 as float) from tblsidpers