Record concat display

jonasalbert20 · #1 (**permalink**) 01-23-07, 01:25

We usually do this in SQL Server...

Code:

declare @a varchar(100)

select @a = isnull(@a, '') + convert(varchar(10), a) + '-'
from (  select 1 as a union all
	select 2 as a union all
	select 3 as a union all
	select 4 as a union all
	select 5 as a 
	) as tbl
select @a = left(@a, len(@a) - 1)
select @a as a

i want is to display this in a single column with a delimeter. On the below example, it is delimeted with a minus sign.

How can we do this?

Result set should be like this...

select '1-2-3-4-5' as a

r937 · #2 (**permalink**) 01-23-07, 08:15

Code:

select group_concat(a separator '-')
from (  select 1 as a union all
	select 2 as a union all
	select 3 as a union all
	select 4 as a union all
	select 5 as a 
	) as t

Internet Services

Web Development

Digital Marketing

Consumer Tech