Using LIKE for Variable

Question

Using LIKE for Variable

craig322 (MIS)

(OP)

13 Mar 02 10:53

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 (Programmer) · Answer 1 · 2002-03-13 13:59:05

You can try

WHERE VENDOR LIKE '&VENDOR|%'

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

wildpetals (Programmer) · Answer 2 · 2002-03-15 09:48:23

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'

Come Join Us!

Posting Guidelines

Using LIKE for Variable