Try this:
create table mytab (num n(20))
* Add some data
alter table mytab alter column num C(20)
? type('num')
brow
alter table mytab alter column number N(20)
? type('num')
brow
You can see the type has changed but the data remains. This must be a free table.
Eric Kleeman - EDS Consulting Services
MCP Visual FoxPro
MCSD C#.NET
Hua Hin Thailand
Los Angeles California