sql Error

[trafmorek]

Can some tell me what i am doing wrong

SELECT SUM(CAST(Admin As numeric (18,2)))+ SUM(CAST(PaidOT As numeric(18,2))) + SUM(CAST(UnpaidOT As numeric(18,2))) AS Total, IBMNum
FROM dbo.DSPActivitySheet
Where (dt BETWEEN @dt AND @dt2 )And( IBMNum=@IBMNum)
GROUP BY IBMNum

I get " error Converting data type varchar to numeric"

 

[cjard]

one of the columns, admin, paidOT or unpaidOT contains an entry that cannot be converted to number