Hi,

If we want compatibility with SQL Server, how should we write this statement?

TEXT TO lcSQL NOSHOW TEXTMERGE 	
	SELECT Trans.cStatus_codes_fk ,;
  	Trans.yReferral_balance_amount, ;
  	IIF(INLIST(cResolution_Codes_fk, <<lcRecalledStr>>),'1','0') as cIsRecalled,
...

where lcRecalledStr is a comma-delimited list of codes.

Thanks.