>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?

Hi Jon,

I've no idea.