Using LIKE for Variable
Using LIKE for Variable
(OP)
I am writing a fex that has the following line:
WHERE VENDOR_NAME CONTAINS '&VENDOR'
I would like this to be a LIKE clause instead so that whatever the user inputs is the first part of the clause. Unfortunately, I have had no luck coding a variable in a like clause. Does anyone have a working syntax to do this?
TIA
WHERE VENDOR_NAME CONTAINS '&VENDOR'
I would like this to be a LIKE clause instead so that whatever the user inputs is the first part of the clause. Unfortunately, I have had no luck coding a variable in a like clause. Does anyone have a working syntax to do this?
TIA
RE: Using LIKE for Variable
WHERE VENDOR LIKE '&VENDOR|%'
I did not try this yet, but it should work.
RE: Using LIKE for Variable
-*) U010FR.FEX Global test for use code.
-SET &FRINPUT = &FRINPUT || '$*';
WHERE FROM_NAME EQ '&FRINPUT'