Using LIKE for Variable

[craig322]

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

 

[jlsnyc]

You can try

WHERE VENDOR LIKE '&VENDOR|%'

I did not try this yet, but it should work.

 

[wildpetals]

in focus... if you're doing a test you can use the string '$*' at the end of a variable to indicate all.. that start with whatever string...

-*) U010FR.FEX Global test for use code.
-SET &FRINPUT = &FRINPUT || '$*';
WHERE FROM_NAME EQ '&FRINPUT'