Hi,

I have a table with blank fields which I would like to reorganize. see picture enclosed (one picture says more than 100 words)
Also enclosed a test,dbf 'table1
Is there an SQL statement to do this, or should I rely on a scan ... endscan statement?
Regards,
Koen