You can change the NULL value for an empty value on the fly with something like:

select iif( isnull( myfield ), 0, myfield ) 
from   mytable

I realize that this might be overkilling for some scenarios, I ignore whether it will be a good aproach in your case.


>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?