Hi,

It's a bug in VFP at reading NVARCHAR datatype from MS SQL server. You can can convert to VARCHAR.

SQLEXEC(handle, "SELECT CAST(NVARCHAR_FIELD AS VARCHAR(n)) AS NVARCHAR_FIELD FROM a Table ")

Of course, the bug fixed in VFP advanced.

MartianJ

>I'm having problems reading data froma SQL Server 2016 table. I can read the values in all fields, but in some characters field i have a space beteween every letter
>
>In SQL Server database management i can see al data normally. For example i have a field called description that contains this string
>"This string"
>
>When i open this table in foxpro with a remote view this field is a Memo field and the value is
>"T h i s s t r i n g"
>
>I have already read data from SQL server database and i never had this problem....
>
>Used both SQL Server Native client 11 or the generic SQL server odbc driver
>
>Some suggests
>
>Thanks