I am working in Info Assist, and I created a text box and found that you have to type the exact word for the report to find what you are looking for. Is there a way to use wild cards directly on the text box? For example if I am looking for my first name, I would have to type exactly 'Krista.' Is there a way I would be able to type 'kr' and my name would be found?

This message has been edited. Last edited by: krhapner,

Hi Krista,

It's all about how you code your WHERE clause.
Instead of having

WHERE FirstName EQ '&Parm';

Consider

WHERE FirstName CONTAINS '&Parm';

But CONTAINS search anywhere in the field the &Parm value, so think about performance.

You can also use LIKE with wild card instead of CONTAINS but you have to manage the wild cards where CONTAINS doesn't need any...

Krista,

If you are concerned about the input case, there is no operator that will ignore it. But what you can do is create 2 define fields. One for the FirstName field that uppercases the field, and then another that uppercases the variable being passed in. You would then compare the two fields in your where statement with the contains operator as Martin pointed out.

[RESOLVED]