Posted by lee on 01/20/07 22:06

Hi

This is a dumb question as I know it's fairly easy but I cant seem to
find an example after two hours of searching.

In a stored procedure I'm trying to build up a string eg,

(the following is in a loop)

IF @xcount > 0
BEGIN
Set @list = @list + @title + ': ' + @xcount
END

Problem is when I come to return @list, it's always NULL - when I know
there should be data returned. Any ideas?

Thanks
Lee

[Back to original message]