>- 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?
Hi Martin -
I am using VFP7 SP1 and the field is defined as nvarchar(255,nullable)
Bill N.