>Come on, permutating the workable T-SQL should not take long
>give us a clue what differentiates working and not working solutions
CHAR(34)+substring(" " +Table.Field, 2, 999999)+CHAR(34)
Works
CHAR(34)+rtrim(Table.Field)+CHAR(34)
Works
CHAR(34)+cast(Table.Field as ...)+CHAR(34)
Works
CHAR(34)+stuff(Table.Field, with no working, "whatever")+CHAR(34)
Can't make this one work.
CHAR(34)+stuff(Table.Field, working, "whatever")+CHAR(34)
Can't make this one work.
CHAR(34)+Table.Field+CHAR(34)
Also works and simpler, but, I need to REPLACE quotes inside the content with a blank so it won't affect the delimiters. I still don't understand why this didn't work in the first place. Now, it does.