Syntax for "IN" or "NOT IN" in progress 4 gl

[mjshinde]

WHEN SUBSTRING(country_code,1,5) = "India" OR WHEN SUBSTRING(country_code,1,5) = "China"

Is it possible to use "In" statement similar to SQL in progress ?
SUBSTRING(country_code,1,5) in ("India", "china")

 

[rzr]

check LOOKUP() function

 

[mjshinde]

check LOOKUP() function

Done Thanks...

DEFINE TEMP-TABLE tt_mjs
FIELD emp_name AS CHAR FORMAT "x(50)"
FIELD region AS CHAR FORMAT "x(25)" .

CREATE tt_mjs .
ASSIGN emp_name = "MJS"
region = "MH" NO-ERROR.
CREATE tt_mjs.
ASSIGN emp_name = "AKS"
region = "GJ" NO-ERROR.
CREATE tt_mjs .
ASSIGN emp_name = "RD"
region = "TN" NO-ERROR.

FOR EACH tt_mjs NO-LOCK:
DISP emp_name WHEN LOOKUP(region, "GJ,MH" ) > 0 .
END.