Good Day Sir,

I need help on creating an 'iif()' expression on my FILTER condition on one of my remote views (using SQL 2000 as database) and VFP8 as IDE.

Heres my code SQL Code on the VFP Designer:

&& --------------------------------------------
WHERE Tblcalls.caseno = ( ?pvcaseno );
AND IIF(?pvpatno=0,Tblcalls.patno>0,Tblcalls.patno=?pvpatno)
&& --------------------------------------------

When I execute this query the it returns a line of:
Incorrect systax near '='

I hope you can help out on this, thank you.

Marlon Estrelon