>Tried filling the numeric value in all rows with a 1 but still got the error :-{

Viv,

One problem that can be ellusive with SQL Server is if a char field has an apostrophe in it, you need to double the apostrophe before inserting into SQL Server. So Jone's becomes Jone''s.

JimB