SQL - Converting from VARCHAR to Decimal

~J~ · 16 Jan 2006 at 15:16

I've got a table which has a field that can hold a multitude of values.

What I want to do is SUM up the field, if it can't convert the text, then it ignores it and/or gives it a zero.

I get an error which reads "Error converting varchar to numeric"

Anyone know how I can SUM up the column, ignoring any errors it finds along the way?

TIA

~J~ · 16 Jan 2006 at 15:26

Ahhh, sorry, using SQL Server 2000.

Tried the Convert and Cast commands, but getting the same error.

~J~ · 16 Jan 2006 at 16:52

Cheers for the help, really appreciated.

SQL - Converting from VARCHAR to Decimal

~J~

~J~

~J~

~J~

~J~

~J~