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)