SQL_Latin1_General_CP850_CI_AS for all.

Instead of me posting the various SQL that I have used to debug, let me just show you everything that I am experiencing.

I have a SQL Server database (SBO_Base) that was...

I'm not physically translating to/from hex.  I am trying to show the hexadecimal equivalent of the result from the ASCII('™') function during operations.  For some reason the ™ on your SQL server is fine and...

I know that if I run this:

SELECT REPLACE('Microsoft™',char(153),'')

The result in hex is: '4D6963726F736F667454'.

The replacement is not occurring because the ™ symbol is being translated to a 'T' (Hex 54) instead...

There is no "M" in the string.  The (TM) symbol is one character Hex 99.

It must be how the database or table is defined.  For some reason, if I run this on my system, it returns "MicrosoftT" from the selection.  The "T" in this...