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

declare @STR

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