Using LIKE for Variable

craig322 · Mar 13, 2002

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 · Mar 13, 2002

You can try

WHERE VENDOR LIKE '&VENDOR|%'

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

wildpetals · Mar 15, 2002

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'

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Using LIKE for Variable

craig322

MIS

jlsnyc

Programmer

wildpetals

Programmer

Similar threads

Part and Inventory Search

Sponsor