I like charindex() for this.

convert the int field to character and wrap in delimiters and then replace the commas in CSV with the delimiters and wrap in delimiters too.

SELECT '|'...

Thanks again Lowell - By the way my name is Joe.

I had considered carrying both, but carrying 2 id's seems excessive because it will be blank for 75% of the...

Ok - but the problem is, sometimes the parent_id could change from another system. That's where I'm getting lost here. I'm trying to avoid using the parent_id as...