>I'm using the view designer, and trying to create (modify, actually) a parameterized view that will allow the user to enter any part of a name for searching.
>What I've tried is SELECT...WHERE...ACCTNAME LIKE UPPER( %?lcAcctName% ).
>
>I've tried it without the UPPER (the names are stored in all uppercase anyway), and with the question mark to the left of the first percent sign, but in no case does it prompt me for the value, and it always returns no records. The variable is not defined; when I remove the percent signs, it prompt me to enter the value.
>
>I haven't used the LIKE operator much, nor the % and _ wildcards, so this is a new area for me.
>
>Thanks for any help.
>Mark
>Mganchrow@networks-inc.net

try: where AcctName LIKE ?lcAcctName

Then the parameter you pass can be anything like:

lcAcctName = "%" + lcMyVar + "%"
lcAcctName = lcMyVar + "%"
lcAcctName = "_" + lcMyvar + "%"
etc...