Hi ,

You can do as

declare @table as table

(id int)

INSERT INTO @table

SELECT 100 UNION ALL

SELECT 101 UNION ALL

SELECT 102 UNION ALL

SELECT 103 UNION ALL

SELECT 104...

You can try this query

declare @nullvalue varchar(1000)

set @nullvalue=''

select @nullvalue=@nullvalue+','+isnull(id,'Null')+','+isnull(Name,'Null')+','+isnull(Sal,'Null') from Table1 where id is null or Name is null or Sal is null

declare @spacevalue varchar(1000)

set @spacevalue=''

select @spacevalue=@spacevalue+id+','+Name+','+Sal from Table1 where...

Thanks Daniel Bowlin,

ConsumeWhiteSpace = True is in SSRS 2008 but I am using SSRS 2005.