>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

What happens to Ids?