>What about if the value you are looking for is parametrized. Such as ?states.
>
>
>if I do the following
>
>with thisform
>*value of txtstates = O
>?states = %+.txtstates
>requery(states)
>endwith
>
>I get an error a syntax error. On a parameterized view is a there a way to pass the % sign. Thanks for reply
>

First, the % is a part of a string, so you'd have to encapsulate it in quotes.

Second, when constructing the view parameter, you don't include the ? in the assignment statement. So your assignment statement from the example above would be:

states = '%' + .txtstates

You could then use:

...LIKE ?states...

in your SQL Select statement (you migth need to define the parameterized view programmatically rather than with the View Designer to build the expression properly; I haven't used the View Designer in a while, at least not since I started using VFP6.)