Why would it, Swen, when you think about it? There's an 80 character limit on both ends so you should be fine. I am working on a remote view as we speak that has beaucoup varchars that I define as Chars on the VFP end.
>Thanks John - I'll give that a try but I'm a disturbed by the fact that even on SQL, with a datatype of varchar(80), the field contains over 2000 (2K) characters. If I change the datatype in the remote view in my VFP database to C(80) won't it truncate it?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05