Home Forums SQL Server 2005 T-SQL (SS2K5) Concatenating fields into one RE: Concatenating fields into one
richardmgreen1
SSChampion
Points: 10303
More actions
July 15, 2014 at 3:51 am
#1729374
Thanks Gail.
I've written the REPLACE to get rid of the x0D's and that bit's worked.
You were right about the UNFIN, it was picking up a previous field that I hadn't filtered out in the sub-select query.
Thanks for all your help.