>How do you change the parameter of a view? If my view was created to query for a name, how can I requery it to search for an address. Or can I?

Whole where expression should be a variable. To be honest, I haven't created views like that but I saw here this technique couple of times. As I recall, Trey Walpole showed it once. I'll try to search here, though I'm not sure, how to search...

Ok, I found this thread Forum: Visual FoxPro Category: Visual FoxPro in general Title: Re: SQL question Thread #334207 Message #334238, which seems to be an answer.

Found another one from Larry Miller to you :) Forum: Visual FoxPro Category: Databases,Tables, Views, Indexing and SQL syntax Title: Re: Paramatized Views. Thread #508811 Message #508823