Hello, I am really struggling with this. I have inherited a MSSQL server and I need to retrive data from a certain table. The problem is some of the data returns like this: "IÆm trying to find out......" Note the problem with the "I'm". The database collation is set to SQL_Latin1_General_CP1_CI_AS. I have tried decoding the string as "Latin1", "ISO-8859-1" and "Windows-1252" and the most I can manage to do is change the "Æ" to a "?". I have also tried to bind the column type to SQL_WCHAR in the script but still it fails to display correctly.

Can anyone help?

EDIT: A regular expression to substitute "Æ" for "'" has worked but I am not too sure this is the correct way to do it??