Ok thanks for that. I will do some testing.

Yes thanks for your answer.

I managed to rectify the problem. The table column in question was varchar(100) but the stored procedure I was using excepted parameters which were char(100)....

Thanks David but not sure what the management studio is. However, I am still using VB6 and will check the connection properties in that. Thanks for your help.

Paul