Hi David,

You're correct that names that doesn't follow the Transact-SQL rules for identifiers mast be quoted. However, the double quotes (ANSI standard) can only de used when SET QUOTED_IDENTIFIER is ON. The square brackets ([]) can be used always and not affected by any settings but they are MS SQL Server specific.

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

>