>Hi all,
>
>I'm wondering how far set filter to in VFP can do the most like in Excel :
>
>Because in Excel we can set filter to any fields in the sheet, can we do the same thing with VFP ?.
>
>Please give the advices , really appreciated in advance.
>TIA

You can put the filter to any condition on a table. The condition can involve one field, or even not name any field at all, such as a filter that involves deleted() or recno().

For example (in a DBF that contains a list of people):

set filter to LastName = "P" && starts with "P"

set filter to Age <= 40

set filter to LastName = "P" and age <= 40 && combined condition

set filter to recno() % 100 = 0 && gets a sample: one in every 100 records

set filter to "x" $ LastName && LastName contains an "x"