Thanks, I'll give it a try.
bn

>Or
>

> select convert(varchar(255),pol1) from tsttable
>

>
> MartinJ
>
>>Martin,
>>
>>Thanks for the info. Since the database if from a third party, I'm not at liberty to make the change. I'll just use STRTRAN() to reformat the data.
>>
>>Again, many thanks for the info.
>>
>>bn
>>
>>>Bill,
>>>
>>> You can change datatype from nvarchar(255) to nvarchar(254) or ntext ?
>>> This bug is only VFP 7.0 and field nvarchar(n) (MS SQL 2000), where n>254.
>>> VFP 6.0 SP5 is OK.
>>>
>>> MartinJ
>>>
>>>
>>>>>- 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)