This seems to work fine. There is no reason it should change just because it is in a view.

if OBJECT_ID('Something') is not null

drop table Something

GO

create table Something

(

ID int,

Type varchar(10),

Term varchar(10)

)

GO

insert Something

select 1, 'Subject', 'sky' union all

select 2, 'Next', 'earth' union all

select 2, 'Subject', 'video' union all

select 3, 'Test', 'black' union all

select 4, 'Subject', 'white' union all

select 4, 'Subject', 'paper' union all

select 4, 'Forms', 'red' union all

select 4, 'Subject', 'stone' union all

select 5, 'Test', 'head' union all

select 6, 'Subject', 'leg' union all

select 6, 'Subject', 'water'

GO

select * from Something

--here is the code not in a view

SELECT id,

Stuff((SELECT ', ' + Term

FROM Something s2

WHERE s1.id = s2.id

and s2.Type = 'Subject'

ORDER BY s2.Term

FOR XML PATH('')), 1, 1, '') as Result

FROM Something s1

where Type = 'Subject'

GROUP BY id

go

create view MyView as

SELECT id,

Stuff((SELECT ', ' + Term

FROM Something s2

WHERE s1.id = s2.id

and s2.Type = 'Subject'

ORDER BY s2.Term

FOR XML PATH('')), 1, 1, '') as Result

FROM Something s1

where Type = 'Subject'

GROUP BY id

go

select * from myview