As in VFP Help for Select -SQL command:
"AS Column_Name
Specifies the heading for a column in the query output. This option is
useful when Select_Item is an expression or contains a field function and
you want to give the column a meaningful name. Column_Name can be an
expression but cannot contain characters (for example, SPACES) that aren't
permitted in table field names"

>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