thanks guys. it works.

I am still getting an error message:
Msg 189, Level 15, State 1, Line 45
The concat function requires 2 to 254 arguments.