how big is your name? if not big and you are using SQL Server, try a SQL like DECLARE @Everything varchar( 8000 ) select @Everything = @Everything + name from tab1 select @Everything as 'Name'dim str as string = YourCommand.ExecuteScalar().ToString()
DECLARE @Everything varchar( 8000 )
select @Everything = @Everything + name from tab1
select @Everything as 'Name'dim str as string = YourCommand.ExecuteScalar().ToString()