Hi Ken,

>TABLEUPDATE simply does not update SQL unicode data types properly. I don't think it is the TABLEUPDATE statement itself, but somewhere between the time you do the TABLEUPDATE and the time the SQL database actuallys gets updated a CHR(0) gets appended to the end of the field, and a side effect of that is padded spaces.

I remember reading about this problem somewhere... awhile ago. Sounds like a VFP problem. If you haven't already, you should make the FoxTeam aware of it - you can catch them lurking around here from time to time. *bg*

>After trying all possibilities we concluded our best option was to write our own routine which dynamically creates the SQL INSERT, UPDATE, and DELETE statements.

Another good argument for SPT.

>(Sorry for the long explanation...I'm a wordy kinda person <s>)

Hey, were all long-winded around here.

>P.S. SCATTER/GATHER? Whats that? <s>

You don't want to know.