Alter colliation conflicts in SQL

 
      ALTER TABLE dbo.warrant_payments ALTER COLUMN ChequeNo
            varchar(36)COLLATE SQL_Latin1_General_CP1_CS_AS  NULL;