No. My answer is first time BEGH, second time BEGH and Third time BEGH. Bcoz these two variables are varchar only. so if u pass the interger value without single quote it will accept.

First time :

insert into #test values

('1','A'),

('','B')

insert into #test values

(2,'D'),

('','E')

insert into #test values

('','G'),

('','H')

go

-- First select statement

select * from #test where c1 = ' '

delete #test

answer :

B

E

G

H

Second time:

insert into #test values

('1','A'),

('','B')

insert into #test values

('2','D'),

('','E')

insert into #test values

('','G'),

('','H')

go

-- Second select statement

select * from #test where c1 = ' '

delete #test

Third Time:

insert into #test values

(1,'A'),

('','B')

insert into #test values

(2,'D'),

('','E')

insert into #test values

('','G'),

('','H')

go

-- Third select statement

select * from #test where c1 = ' '

answer :

B

E

G

H

Note: So all three times the value comes same value only in SQLSERVER 2005