>>TEXT TO lcSQL NOSHOW TEXTMERGE >> SELECT Trans.cStatus_codes_fk ,; >> Trans.yReferral_balance_amount, ; >> IIF(INLIST(cResolution_Codes_fk, <<lcRecalledStr>>),'1','0') as cIsRecalled, >>...>>
> SELECT Trans.cStatus_codes_fk ,; > Trans.yReferral_balance_amount, ; > CASE WHEN cResolution_codes_fk IN( << lcRecalledStr >> ) THEN '1' ELSE '0' END as cIsRecalled, > >Right, but I want to have something which I can use without changes in both SQL and VFP. Also I just found I can not use INLIST, I have more than 24 codes.