I believe that the second portion, "trying to concactinate NULL values" could be a good start in finding out why it is not working. Thanks again.

Thank you for the quick reply and yes, I tested your code and it works fine on my system so, in theory, I should have a syntax error.

Taking my example...

Does anyone actually test this code or is most of this stuff just rumors?

According to most of the information I should be able to create multiple variables...

DECLARE @SELECT varchar(100)

DECLARE @FROM...