I just tested this:

set nocount on;

if object_id(N'tempdb..#testcases') is not null

drop table #testcases;

CREATE TABLE #testcases(

[testcase_id] [int] IDENTITY(1,1) NOT NULL,

[ScenarioName] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[scenario_category] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[expected_bundles] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[expected_promotions] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[on_order] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[on_profile] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Change_to] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[creation_date] [datetime] NULL,

[user_name] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

CONSTRAINT [PK_crmm_testcase] PRIMARY KEY CLUSTERED

(

[testcase_id] ASC

)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

);

insert into #testcases ([ScenarioName])

select '[Change6]-[Existing Customer]-[FE / FDV + Video SPL FL DCT with VTP = NO]';

select *

from #testcases;

select *

from #testcases

where [ScenarioName] = '[Change6]-[Existing Customer]-[FE / FDV + Video SPL FL DCT with VTP = NO]';

Both select statements returned the correct results.

What do you get when you run that script?