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