here is an exemple

SELECT Detmvt.NUMDET, case when Detmvt.SENS=1 then 'DEBIT' else 'CREDIT' end as libelle
FROM dbo.DETMVT Detmvt

that works on sqlserver side but in vfp 9 remote view this doesn't work.
here the error message :
COMMAND CONTAINS UNRECOGNIZED PHRASE/KEYWORD

I don't understand.