>As Replace fails, my gut hunch to force
>CHAR(34)+substring(" " + rtrim(Table.Field), 2, 999999)+CHAR(34)
>will probably fail as well - but easy to check...
Ok, I'm impressed. This works. But, what does it do exactly?
As I have quotes in that field, I added REPLACE(Table.Field,'"','') in order to avoid a conflict.