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

If you select records into a cursor, you can have long field names. If you select into a table, then it creates a free table and you can not use long names (more than 10 chars).