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

Not sure I've got the exact syntax right but how about something like

	SELECT Trans.cStatus_codes_fk ,;
  	Trans.yReferral_balance_amount, ;
  	CASE WHEN cResolution_codes_fk IN( << lcRecalledStr >> ) THEN '1' ELSE '0' END as cIsRecalled,