>select myfieldname from table ....
>
>when the field name is longer than 9 characters foxpro truncate it. how can i have long column name ?

A field name is limited to 10 charters for free tables. Only tables in DBC and cursors can have longer field names (up to 128).