>I have an app that has this query. Note the ASCAN() command:
>
>

>SELECT rcm_pk, cmt_custname, rlc_number;
>	FROM RailComp, RailCars, CustMast;
>	WHERE rcm_rlc_fk = rlc_pk AND;
>		  rcm_custcode = cmt_custcode AND;
>		  NOT DELETED() AND;
>		  NOT rlc_final_bill AND;
>		  rlc_rectype = "R"  AND;
>		  ASCAN(laCustCode,custmast.cmt_custcode,1) > 0;
>	ORDER BY rcm_custcode, rlc_number, rcm_compdesc;
>	INTO CURSOR WouSel;
>

>

Just want to comment that ASCAN() in a query is a bad idea because it's controlled by SET EXACT, but the query's controlled by SET ANSI.


>
>I tried to change it to use a dynamically created cusstomer list, but I get a 'Line is too long' error when I
>select all customers:
>
>
>

>SELECT rcm_pk, cmt_custname, rlc_number;
>	FROM RailComp, RailCars, CustMast;
>	WHERE rcm_rlc_fk = rlc_pk AND;
>		  rcm_custcode = cmt_custcode AND;
>		  NOT DELETED() AND;
>		  NOT rlc_final_bill AND;
>		  rlc_rectype = "R"  AND;
>		  INLIST(rcm_custcode, 'ABCDE','ABL24','ACA30','ACM17');
>	ORDER BY rcm_custcode, rlc_number, rcm_compdesc;
>	INTO CURSOR WouSel;
>

>
>Is there a way to do this with a join?

Throw the list into a cursor and join the cursor.

Tamar