I'm just using the snippet that is posted, the only difference is that I declared the table instead.

declare @Address table

(systemID int, Locations varchar(16))

insert into @Address select 1001, 'CA'...

Hi Lynn,

Thanks for your help on this I really appreciate it. I'm using SQL2005. Any ideas?

Hmm, interesting I have never used "FOR xml path" before. However, It return this uggly error. Thanks for your respond.

Msg 170, Level 15, State 1, Line 9

Line 9: Incorrect syntax...