>>>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,
>>
>>
>
>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.
I don't think you'll be able to write something that will work on both databases. At least not something reasonably simple and maintainable.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________