SQL Server 2005: Arithmetic overflow error converting int to data type numeric

Question

I have to filter a column called [Order] (data type = decimal(3,1)) in my final view for 1.0.

List of unique values for [Order] are:

• 1.0
• 2.0
• 3.0
• 4.0
• 5.0
• 7.0
• 8.0
• 9.0
• 11.0
• 12.0
• 13.0

My SQL Statement is as follows:

SELECT
        [Order]
FROM
        [dbo].[vwCoreData_AllOtherCats]
WHERE
        [MEDate] = '2/29/2008'
    and [Order] = 1
--  and [Order] = 1.0
--  and [Order] = cast(1 as decimal(3,1))
--  and [Order] = cast(1.0 as decimal(3,1))

The commented-out lines shows the different methods I've tried. All 4 ways results in the same error message:

Msg 8115, Level 16, State 8, Line 1

Arithmetic overflow error int to data type numeric

Anyone know what is going on here?

Thanks for any help anyone can provide,

CTB