>I built a FILTER that grows as one moves from field to field entering text into textboxes on a form. Or the user may enter just text in on field, it varies. The FILTER is working great, but...
>
>I want to be able to search on partially entered text in the same textbox fields and still use my all-inclusive FILTER.
>
>For example,
>I want to search on an address field where the user does not have to enter the whole address, but can press a command search button at any time.
>
>The user might type in ADDRESS as follows:
>3432 Broa instead of 3432 Broadway Ave. and they hit the search command button. So the condition of my filter would not be "=", but something other than "=".
>
>This might be an easy one, but I have never done it and I am fried on Friday afternoon. Can someone help me out? Thanks very much.
>

It depends what is final command in search: SEEK or SELECT-SQL
If it's SEEK, then look at SET EXACT OFF or it might be combination of SET EXACT ON and SET NEAR ON.
If it's SELECT-SQL then default SET ANSI OFF will do this job.
Basically, if you will read SET EXACT help article (string comparison part) and still feel good :) then it's Ok.