Using a Parameter Field for Partial Text Matches 1

[dbielenda]

I am using this formula:

(If {?Parameter} = "" then true
else
If Instr ({?Parameter}, "?&quot > 0 then {TABLENAME.FIELD} like {?Parameter}
or
If Instr ({?Parameter}, "*&quot > 0 then {TABLENAME.FIELD} like {?Parameter}
else {?Parameter} = {TABLENAME.FIELD})

If the user does not enter anything, then give me all. However, these partial text matches are not working quite the way I hoped. Any suggestions on what I am doing wrong here? Thanks!

 

[FoxG]

Hi,

{fieldname} like {?param}

would actually cater for all of these possibilities.

Where * is the multi character replacement
? is the single character replacement.

Hth,
Geoff

 

[dbielenda]

Thank you.. I just figured that out yesterday. This formula was a suggestion in a book I just bought, then I realized I could simplify it by doing what you suggested