fixed it with: fieldterminator = ''|'',

yah I see that now so I requested a new col and that contain an id to link the rows; modified the query and it works

https://www.idera.com - looks like it has some interesting tools for free

pietlinden,

Included in the original post:

--tblOrder

--Keysv

--72apple

--72orange

--73100

--73100

--desired end results

--idd

--7Value of apple 100

--7Value of orange 100

Below are the create and insert stmts:

--table create

CREATE TABLE [dbo].[tblOrder](

[Key] [int] NOT NULL,

[varchar](50) NOT NULL,

[v]...

Luis - working on a project that has it setup as follows:

key - is a foreign key to a primary key in another table

s - is a setting id --...

think this will work:

select replace(stuff((select ' ' + oap from @OAP for xml path('')),1,1,''),'</br >', '</br>')

that produced:

apple1</br > apple2</br >

so how do i get to:

apple1</br>apple2</br>

Thanks, Lynn - not sure how I over thought that....