View Single Post
 
Old May 6th, 2005, 12:55 PM
gbianchi gbianchi is offline
Friend of Wrox
Points: 7,395, Level: 36
Points: 7,395, Level: 36 Points: 7,395, Level: 36 Points: 7,395, Level: 36
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Capital Federal, , Argentina.
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

hi there..

you should depure this.. but thinking something like

SELECT
iif(isnull(pgcd1),"",pgcd1+"|")+... etc

i dont remember exact function for sql server.. but after that you will have to take always the last "|" ..



HTH

Gonzalo