>thanks friend
>but i want to create view in ms sql not in vfp
You want SQL Server view?
Nope, you can't. SQL Server views doesn't work with parameters. But You can create a Stored Procedure that can extract the records you need.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.