>I am transfering data from Access to VFP with ODBC.
>
>It woking find using remote view but some field that I transfer have Null value.
>Is there a way prevent having Null in my Select SQL Result?
You can use the NVL function:
select NVL(custName, "") as cCustName from ...
Steve Gibson