Try the following:

SELECT ... WHERE ..... ?lcAcctName $ acctname. Make sure you ALLTRIM() blanks off of lcAcctname and ensure that case will match. (upper, low)


>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