View Single Post
 
Old May 6th, 2005, 01:20 PM
shahchi1 shahchi1 is offline
Friend of Wrox
 
Join Date: Jan 2004
Location: , , USA.
Posts: 303
Thanks: 0
Thanked 0 Times in 0 Posts
Default

SELECT CASE
       WHEN (column1 IS NOT NULL) THEN column1 + space(1) + '|' + space(1) ELSE '' END +
       CASE
       WHEN (Column2 IS NOT NULL) THEN column2 + space(1) + '|' + space(1) ELSE '' END +
       CASE
       WHEN (Column3 IS NOT NULL) THEN column3 + space(1) + '|'+ space(1) ELSE '' END
From MyTable