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