>>>Just playing around with SQL 7. You have captions for fields in VFP and Access. Why not SQL? Am I stupid, blind or both?
>>>
>>>
>>>Jeff
>>
>>Because Field names can be very nearly anything, you don't really need this capability in SQL Server (IMO).
>>
>>create table mytable ([Last Name] varchar(20),[First Name] varchar(15))
>
>Yes you can. But it is a very very bad idea to create fields with imbedded spaces (IMHO). You are setting yourself up for all sort of PITA problems when you start doing queries againsts it.

If you enclose them in quotes, you shouldn't have any problems. It just makes for really long SQL statements. ;-)