SQL Server - Convert varchar to another collation (code page) to fix character encoding
select
columnName collate SQL_Latin1_General_CP1_CI_AS
from tableName

select
cast (columnName as varchar(100)) collate SQL_Latin1_General_CP1_CI_AS
from tableName

select
convert (varchar, columnName) collate SQL_Latin1_General_CP1_CI_AS
from tableName

CREATE DATABASE [Test] ON  PRIMARY
    (
    NAME = N'Test'
    , FILENAME = N'...Test.mdf'
    , SIZE = 3072KB
    , FILEGROWTH = 1024KB
    )
    LOG ON
    (
    NAME = N'Test_log'
    , FILENAME = N'...Test_log.ldf'
    , SIZE = 1024KB
    , FILEGROWTH = 10%
    )
    COLLATE SQL_Latin1_General_CP850_BIN2
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MyTable]
    (
    [SomeCol] [varchar](50) NULL
    ) ON [PRIMARY]
GO
Insert MyTable( SomeCol )
Select '±' Collate SQL_Latin1_General_CP1_CI_AS
GO
Select SomeCol, SomeCol Collate SQL_Latin1_General_CP1_CI_AS
From MyTable