i think u may be want to get that like this:

declare @str

select @str=@str+colour +'|' from youtablename order by id