>Does anyone know how I can implement IIF statements in an SQL. I am running a SQL select statement that looks for the patient id but the problem arises when the patient has two different visit dates to the doctor. but I only need the latest date.

Sure...

SELECT patname, iif(pattype = "A","ACUTE  ","CHRONIC") as ptype ;
   FROM patient
   INTO CURSOR cPats