Hi everyone,

I have a table that looks like this...

PID evacCodeNoteCd
12 EVAC1OXY
12 EVAC2IV
12 EVACOTH

and I'd like to return this...

EVAC1OXY/EVAC2IV/EVACOTH

So how can I concatenate multiple rows into one field?

Declare @lvcConcat Varchar(8000)
,@lvcLocalVar
SELECT @lvcConcat = ''
Declare cursor concat_rows for
select evacCodeNoteCd from Table_Name
Open Cursor
Fetch cursor into @lvcLocalVar
WHILE(@@sqlstatus = 0)
BEGIN
SELECT @lvcConcat = @lvcConcat+ @lvclocalVar
Fetch cursor into @lvcLocalVar
END
SELECT LTRIM(RTRIM(@lvcConcat))

Thanks for the suggest. Using cursors works, but I was hoping there was a simpler solution.