Hi Mo,

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

You can't have a space in field name, or in variable name, or in program name, or in object name. You can to use a separator like "_" or you can to use capital letter and minuscule letter "FieldName".
Bye!