Did you read BOL like I suggested? (Not trying to dance around the answer -- just trying to encourage you to look it up and figure it out on your own before asking questions, which is highly encouraged in this forum.)

There are a number of data types that will do this for you. For example, try DECIMAL.

Try messing with the numbers (including the 4 and 1 in the decimal declaration) in this example in your SQL and see what it does for you . . .

declare @number decimal(4,1)

select @number = 10.2436

select @number