>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.
That's sql server syntax, and should work on the remote view only, not on VFP data. IOW, you need two views.