Hi Sergey,

Thanks for all your help you were dead right, the collation on our server is Latin1_General_CI_AS and their's is Latin1_General_BIN.

From a longer term point of view we need to change our application to deal with this. From a short term point of view I was going to get them to change their collation on just the database we are accessing to Latin1_General_CI_AS. Do you know if there is anything that we need to take into consideration before implementing this short term approach?

Thanks again for all your help its much appreciated.

Jon