>>Curious minds might now abolish some parts of working statement
>>CHAR(34)+substring(" " +Table.Field, 2, 999999)+CHAR(34)
>>CHAR(34)+rtrim(Table.Field)+CHAR(34)
>>CHAR(34)+cast(Table.Field as ...)+CHAR(34)
>>CHAR(34)+stuff(Table.Field, with no working, "whatever")+CHAR(34)
>>CHAR(34)+stuff(Table.Field, working, "whatever")+CHAR(34)

Come on, permutating the workable T-SQL should not take long
give us a clue what differentiates working and not working solutions