I want to convert the columns of varchar(400) into a single row. i tried using coalesce but it doesnt works for large amount of data
can anyone please help me in this.

this is the snapshot of table which i am using:---

D0201 as [Nominee Emp No]
D0202 as [Nominee DU Code]
D0203 as [Nominee Project Code]
D0204 as [Nominee DM Email ID]
D0205 as [Nominee Location]
D0206 as [Nominator Email ID]
D0307 as [Specialized domain competency (eg. RETL, Banking, Insurance)]
D0308 as [Quantify the benefits (for e.g. Due to domain competency the KT was given in a day and this resulted]
D0309 as [Any domain specific certifications]
D0310 as [Paper presentation in domain area ]
D0323 as [K-Shop Material]

the coalesce is able to convert into a single row of length 256 characters max, whereas in my case it will go beyond 2000.
Any pointers will be of great help.

Regards
Rahul Pokharna

__________________
regards
rahul pokharna

What is the code you are using? Why not just concatenate into a column or variable of VarChar(8000)?

Jim

thanks jim for ur reply. the max length for a columns was set to 256 only. i reseted it to 8000 and it is working fine now.

regards
rahul pokharna

Glad you got it working