- Have you VFP 6.0 without SP5?
- Is type field on SQL NTEXT or NCHAR?
MartinJ
>I have a Remote View through an ODBC connection to a SQL table.
>
>The SQL table text field is assigned to a memo field in the remote view and imports the data with a CHR(0) following each character.
>
>If I access the table with the same ODBC connection using MSQRY32, it displays the data correctly.
>
>I could use STRTRAN() to rid the field of the CHR(0)'s, but is there a better way?