declare @mprecent numeric(10,6) set @mprecent = (10.0/100) --2 int makes division,the result still is an int print cast(@mprecent as char)