Mo,
As the others have said, you can not have a space in the column name in VFP. SQL Server columns can have spaces in them, but then you have to keep using " around the field names:
create table #test ( "field with spaces" char(20), test int )
insert into #test values ( 'does it work', 100 )
select * from #test
select "field with spaces" from #test
>select fieldname as "field name" from tablexx
>result in an error
>
>select fieldname as field_name from tablexx
>work fine.
>
>am I doing anything wrong or it can not be done, yet.
>I thought we used to be able to do that. or I am mixing VFP with other tool.