>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;
>

>
>
>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?

I didn't read the whole thread yet, but one thing immediatelly caught my attention - you can not use deleted() function if there are more than 1 tables in the FROM clause.