select column names from table

[jamesd0142]

I use this code:
[code=sql]
select coalesce(COLUMN _NAME, '') + ',' from INFORMATION_SCH EMA.COLUMNS where TABLE_NAME = 'Learner'
[/code]

I get ouput like:
LN01,
LN02,
LN03,
...
LN15,

I need the output to look like 1 single string

Like:

LN01,LN02,LN03, ...LN15,

Can any1 advise?

James

[ck9663]

Start from here

-- CK