General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Lal,
The INLIST() function doesn't like a vbl like your supplying. For instance,
lcList = ["A","B","C"]
*--This will return 0 records
SELE * FROM CUSTOMERS WHERE INLIST(custno, lcList)
*--Using macro expansion, like this, rtns the results that you're looking for.
SELE * FROM CUSTOMERS WHERE INLIST(custno, &lc_List.)
HTH
-Matt
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only