1: SELECT CASE WHEN IsNumeric(YourColumn) = 0 THEN
2: 0
3: ELSE
4: CAST(YourColumn AS decimal(18, 2))
5: END
http://stackoverflow.com/questions/1559472/sql-server-converting-a-variable-varchar-field-to-money-decimal-something-with-d