View Single Post
 
Old May 6th, 2005, 02:11 PM
rgerald rgerald is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Naperville, IL, USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Try this sample:

Code:
DECLARE @s1 varchar(10)
DECLARE @s2 varchar(10)
DECLARE @s3 varchar(10)
DECLARE @s4 varchar(30)

SET @s1 = NULL
SET @s2 = 'two'
SET @s3 = 'three'

SET @s4 = '|' + isnull(@s1 + '|', '') + isnull(@s2 + '|', '') + isnull(@s3 + '|', '')
Print @s4
Rand