>I am doing a standard VFP 6.0 SQLEXEC() against the Northwind database (SQL 2000) and the resulting set has strange characters in the address and extension fields.
>
>SQLEXEC(
>SQL shows an extension of 3457
>VFP shows an extension of 345|
>
>Also, when you tab onto the field in the browse window, the strange character is not visible, just the 345.
>
>The ASC() translation of the characters are 10 and 13.I am trying to write a solution that will take the resulting query and output it to an excel spread sheet. However, with the characters changing the resulting field values it won't be of much use. Has anyone exeperienced this?

It could be a conversion from unicode (nvarchar) problem. Try converting to varchar() like so:

Select Convert(varchar(10),extension) as myext from mytable

HTH