>Hi All,
>
>Is it possible to do something like alter table or so, to create a primary index With a filter clause???
>

This cna be done; the VFP6 SP3 added the ability to specify a filter clause as a part of the ALTER TABLE command that creates a primary key.

>I know this can be done with candidate indexes, but I don't know how to switch a candidate to primary.
>
>The filter clause is : !deleted()
>
>
>Kind regards,
>Wim Dieke