how to using matches in browse mainten ?

[judy]

hi every one,

I have a problem with browse maintenance(36.20.13).
I want to build a browse for Pt_mstr field pt_part, pt_desc1 pt_desc2.
e.g: when run browse , pt_part entry the "11" will disp all part contains "11". so, I use the browse maintenance where clause, eg: where pt_part mathes "11".
but I don't know how to using matches variable, eg: where pt_part mathes("*" + input pt_part + "*")?
how can i handle it?

 

[falcor]

Matches Operator

Hi Judy

Matches is an operator therfore you don't need to use parenthesis.
After matches you put a string which describe the string you look for.
Use * (an asterisk) to represent any number of characters (include a null group).
Use . (a period) to represent one single character.

This is the syntax for your script: where pt_part matches "*11*"

Good luck !

 

[judy]

thanks falor.
but I hope to achieve the aim as follows:
when I run the lookup(eg:gplu340.p), when I input "test" at the "item number" field, I'd like the result display the record of item number contain "est".
I think it want to modfied the program "lookup.i".