>select alltrim(str(int(number))) as number from table into table1

Strange, it may even be a bug if it works for CURSOR but not TABLE. Two options, SELECT INTO CURSOR and copy to a DBF, or use TRAN(number) instead of Alltrim(Str())

* UPdate, saw that this was 2x, no TRAN(), sorry.